David  Keebler

David Keebler

1634266800

How to Change My Web Tab Color for Safari

In this video, I’ll show you two ways to change the tab color for Safari in two ways: 
1. HTML: add a meta tag
2. JavaScript: update the tab color dynamically with CSS variables (including when switching to and from dark mode)

# Timestamps
0:00 Introduction
0:42 Adding meta tag name="theme-color"
1:32 Update theme color with CSS variables
3:41 Updating theme color when switching light/dark modes

#safari  #html 

What is GEEK

Buddha Community

How to Change My Web Tab Color for Safari
Ashish parmar

Ashish parmar

1627043546

Evolution in Web Design: A Case Study of 25 Years - Prismetric

The term web design simply encompasses a design process related to the front-end design of website that includes writing mark-up. Creative web design has a considerable impact on your perceived business credibility and quality. It taps onto the broader scopes of web development services.

Web designing is identified as a critical factor for the success of websites and eCommerce. The internet has completely changed the way businesses and brands operate. Web design and web development go hand-in-hand and the need for a professional web design and development company, offering a blend of creative designs and user-centric elements at an affordable rate, is growing at a significant rate.

In this blog, we have focused on the different areas of designing a website that covers all the trends, tools, and techniques coming up with time.

Web design
In 2020 itself, the number of smartphone users across the globe stands at 6.95 billion, with experts suggesting a high rise of 17.75 billion by 2024. On the other hand, the percentage of Gen Z web and internet users worldwide is up to 98%. This is not just a huge market but a ginormous one to boost your business and grow your presence online.

Web Design History
At a huge particle physics laboratory, CERN in Switzerland, the son of computer scientist Barner Lee published the first-ever website on August 6, 1991. He is not only the first web designer but also the creator of HTML (HyperText Markup Language). The worldwide web persisted and after two years, the world’s first search engine was born. This was just the beginning.

Evolution of Web Design over the years
With the release of the Internet web browser and Windows 95 in 1995, most trading companies at that time saw innumerable possibilities of instant worldwide information and public sharing of websites to increase their sales. This led to the prospect of eCommerce and worldwide group communications.

The next few years saw a soaring launch of the now-so-famous websites such as Yahoo, Amazon, eBay, Google, and substantially more. In 2004, by the time Facebook was launched, there were more than 50 million websites online.

Then came the era of Google, the ruler of all search engines introducing us to search engine optimization (SEO) and businesses sought their ways to improve their ranks. The world turned more towards mobile web experiences and responsive mobile-friendly web designs became requisite.

Let’s take a deep look at the evolution of illustrious brands to have a profound understanding of web design.

Here is a retrospection of a few widely acclaimed brands over the years.

Netflix
From a simple idea of renting DVDs online to a multi-billion-dollar business, saying that Netflix has come a long way is an understatement. A company that has sent shockwaves across Hollywood in the form of content delivery. Abundantly, Netflix (NFLX) is responsible for the rise in streaming services across 190 countries and meaningful changes in the entertainment industry.

1997-2000

The idea of Netflix was born when Reed Hastings and Marc Randolph decided to rent DVDs by mail. With 925 titles and a pay-per-rental model, Netflix.com debuts the first DVD rental and sales site with all novel features. It offered unlimited rentals without due dates or monthly rental limitations with a personalized movie recommendation system.

Netflix 1997-2000

2001-2005

Announcing its initial public offering (IPO) under the NASDAQ ticker NFLX, Netflix reached over 1 million subscribers in the United States by introducing a profile feature in their influential website design along with a free trial allowing members to create lists and rate their favorite movies. The user experience was quite engaging with the categorization of content, recommendations based on history, search engine, and a queue of movies to watch.

Netflix 2001-2005 -2003

2006-2010

They then unleashed streaming and partnering with electronic brands such as blu-ray, Xbox, and set-top boxes so that users can watch series and films straight away. Later in 2010, they also launched their sophisticated website on mobile devices with its iconic red and black themed background.

Netflix 2006-2010 -2007

2011-2015

In 2013, an eye-tracking test revealed that the users didn’t focus on the details of the movie or show in the existing interface and were perplexed with the flow of information. Hence, the professional web designers simply shifted the text from the right side to the top of the screen. With Daredevil, an audio description feature was also launched for the visually impaired ones.

Netflix 2011-2015

2016-2020

These years, Netflix came with a plethora of new features for their modern website design such as AutoPay, snippets of trailers, recommendations categorized by genre, percentage based on user experience, upcoming shows, top 10 lists, etc. These web application features yielded better results in visual hierarchy and flow of information across the website.

Netflix 2016-2020

2021

With a sleek logo in their iconic red N, timeless black background with a ‘Watch anywhere, Cancel anytime’ the color, the combination, the statement, and the leading ott platform for top video streaming service Netflix has overgrown into a revolutionary lifestyle of Netflix and Chill.

Netflix 2021

Contunue to read: Evolution in Web Design: A Case Study of 25 Years

#web #web-design #web-design-development #web-design-case-study #web-design-history #web-development

prashant patil

1598286700

whatsapp web-w app web-webs whatsapp »

Through whatsapp web you can easily run whatsapp on your android pc on your android mobile. Just like whatsapp mobile is for android device, whatsapp web is for windows device. Whatsapp web is quite popular which has quite cool features.

whatsapp web

how to use whatsapp web desktop
Whatsapp web is very easy to use. Simply you have to search web.whatsapp.com in your google chrome and click on first result which is the official website of whatsapp web.

As soon as you click, an interface will open in front of you, on which you will see a barcode. Follow the steps given below to use whatsapp web on your desktop

web.whatsapp.com

open your whatsapp on your mobile
You will see 3dots on the right side top inside whatsapp, you have to click
The 3rd option is whatsapp web, you have to click it
Now you have to capture the barcode you see on your desktop through your phone.
Now you can use whatsapp of your android mobile in your desktop
webs whatsapp

note: You can see whatsapp of anyone’s mobile by pointing to the barcode of your desktop. You can also call it whatsapp hack.

Remember that after using whatsapp web, logout it from your desktop. To logout follow the steps given below.

w app web

open your whatsapp on your mobile
You will see 3dots on the right side top inside whatsapp, you have to click
The 3rd option is whatsapp web, you have to click it
You will see the symbol for logout, you have to logout by clicking it.

read more

#whatsapp #whatappweb #https://web.whatsapp.com/ #wsp web #web.whatsapp web #web whatsapp

坂本  篤司

坂本 篤司

1633790520

SQLServerの50の重要なクエリ

この記事では、いくつかの汎用SQLクエリについて説明します。各開発者はこれらのクエリの知識を持っている必要があると思います。これらのクエリは、SQLの特定のトピックとは関係ありません。しかし、そのようなクエリの知識はいくつかの複雑なタスクを解決することができ、多くのシナリオで使用される可能性があるため、これらのクエリに関する記事を書くことにしました。

クエリ1:すべてのデータベースのリストを取得する

EXEC  sp_helpdb 

クエリ2:ストアドプロシージャ、トリガー、ビューのテキストを表示する

exec  sp_helptext @objname =  'Object_Name'  

クエリ3:データベースに関連するすべてのストアドプロシージャを取得する

SELECT DISTINCT o.name, o.xtype  
  
FROM syscomments c  
  
INNER JOIN sysobjects o ON c.id=o.id  
  
WHERE o.xtype='P'  

ビューを取得するには、「P」の代わりに「V」を使用し、関数には「FN」を使用します。

クエリ4:テーブルに関連するすべてのストアドプロシージャを取得する

SELECT DISTINCT o.name, o.xtype  
  
FROM syscomments c  
  
INNER JOIN sysobjects o ON c.id=o.id  
  
WHERE c.TEXT LIKE '%Table_Name%' AND o.xtype='P'   

ビューを取得するには、「P」の代わりに「V」を使用し、関数には「FN」を使用します。

クエリ5:データベースのすべてのインデックスを再構築する

EXEC sp_MSforeachtable @command1="print '?' DBCC DBREINDEX ('?', ' ', 80)"  
  
GO  
  
EXEC sp_updatestats  
  
GO

例

クエリ6:ストアドプロシージャのすべての依存関係を取得する

このクエリは、使用しているすべてのオブジェクト名を、テーブル、ユーザー定義関数、別のストアドプロシージャなどのストアドプロシージャに返します。

 

;WITH stored_procedures AS (  
  
SELECT  
  
oo.name AS table_name,  
  
ROW_NUMBER() OVER(partition by o.name,oo.name ORDER BY o.name,oo.name) AS row  
  
FROM sysdepends d  
  
INNER JOIN sysobjects o ON o.id=d.id  
  
INNER JOIN sysobjects oo ON oo.id=d.depid  
  
WHERE o.xtype = 'P' AND o.name LIKE '%SP_NAme%' )  
  
SELECT Table_name FROM stored_procedures  
  
WHERE row = 1  

クエリ7:データベース内のすべてのテーブルのバイトサイズを検索する

 SELECT sob.name AS Table_Name,  
  
SUM(sys.length) AS [Size_Table(Bytes)]  
  
FROM sysobjects sob, syscolumns sys  
  
WHERE sob.xtype='u' AND sys.id=sob.id  
  
GROUP BY sob.name

 

クエリ8:ID列を持たないすべてのテーブルを取得します

SELECT  
  
TABLE_NAME FROM INFORMATION_SCHEMA.TABLES  
  
where  
  
Table_NAME NOT IN  
  
(  
  
SELECT DISTINCT c.TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS c  
  
INNER  
  
JOIN sys.identity_columns ic  
  
on  
  
(c.COLUMN_NAME=ic.NAME))  
  
AND  
  
TABLE_TYPE ='BASE TABLE'  

クエリ9:データベース全体の主キーと外部キーのリスト

SELECT  
  
DISTINCT  
  
Constraint_Name AS [Constraint],  
  
Table_Schema AS [Schema],  
  
Table_Name AS [TableName] FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE  
  
GO

例

クエリ10:特定のテーブルの主キーと外部キーのリスト

SELECT  
  
DISTINCT  
  
Constraint_Name AS [Constraint],  
  
Table_Schema AS [Schema],  
  
Table_Name AS [TableName] FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE  
  
WHERE INFORMATION_SCHEMA.KEY_COLUMN_USAGE.TABLE_NAME='Table_Name'  
  
GO

 

クエリ11:すべてのテーブルのRESEED ID

EXEC sp_MSForEachTable '  
  
IF OBJECTPROPERTY(object_id(''?''), ''TableHasIdentity'') = 1  
  
DBCC CHECKIDENT (''?'', RESEED, 0) 

 

クエリ12:レコード数のあるテーブルのリスト

CREATE TABLE #Tab  
  
(  
  
Table_Name [varchar](max),  
  
Total_Records int  
  
);  
  
EXEC sp_MSForEachTable @command1=' Insert Into #Tab(Table_Name, Total_Records) SELECT ''?'', COUNT(*) FROM ?'  
  
SELECT * FROM #Tab t ORDER BY t.Total_Records DESC;  
  
DROP TABLE #Tab;  

クエリ13:SQLServerのバージョン名を取得します

SELECT @@VERSION AS Version_Name  

クエリ14:SQLServerの現在の言語を取得する

SELECT  @@ LANGUAGE  AS  Current_Language;  

クエリ15:テーブルのすべての制約を無効にする

ALTER TABLE  Table_Name NOCHECK  CONSTRAINT ALL    

クエリ16:すべてのテーブルのすべての制約を無効にする

EXEC  sp_MSForEachTable'ALTER  TABLE?NOCHECK CONSTRAINT ALL '  

クエリ17:現在の言語IDを取得する

SELECT @@LANGID AS 'Language ID'  

クエリ18:サーバーで現在設定されている小数および数値で使用される精度レベルを取得します

SELECT  @@ MAX_PRECISION  AS 'MAX_PRECISION'   

クエリ19:SQLServerのサーバー名を返す

SELECT @@SERVERNAME AS 'Server_Name'  

クエリ20:SQLServerが実行されているレジスタキーの名前を取得します

SELECT  @@ SERVICENAME  AS 'SERVICE_NAME' 

クエリ21:現在のユーザープロセスのセッションIDを取得する

SELECT  @@ SPID  AS 'SESSION_ID' 

クエリ22:TEXTSIZEオプションの現在の値を取得する

SELECT  @@ TEXTSIZE  AS 'Text_Size'   

例

クエリ23:ハードディスクの空き容量を取得する

EXEC master..xp_fixeddrives  

 

クエリ24:特定のトリガーを無効にする


構文
 

ALTER TABLE  Table_Name DISABLE  TRIGGER  Trigger_Name   

ALTER TABLE Employee DISABLE TRIGGER TR_Insert_Salary  

クエリ25:特定のトリガーを有効にする

構文
 

ALTER TABLE  Table_Name ENABLE  TRIGGER  Trigger_Name   

ALTER TABLE Employee ENABLE TRIGGER TR_Insert_Salary  

クエリ26:テーブルのすべてのトリガーを無効にする

以前のクエリを使用してテーブルのすべてのトリガーを無効または有効にすることができますが、トリガー名の代わりに「ALL」を置き換えます。

構文
 

ALTER TABLE  Table_Name DISABLE  TRIGGER ALL    

ALTER TABLE Demo DISABLE TRIGGER ALL  

クエリ27:テーブルのすべてのトリガーを有効にする

ALTER TABLE  Table_Name ENABLE  TRIGGER ALL    

ALTER TABLE Demo ENABLE TRIGGER ALL  

クエリ28:データベースのすべてのトリガーを無効にする

sp_msforeachtableシステムストアドプロシージャを使用して、データベースのすべてのトリガーを有効または無効にします。

構文

Use Database_Name  
  
Exec sp_msforeachtable "ALTER TABLE ? DISABLE TRIGGER all"  

クエリ29:データベースのすべてのトリガーを有効にする

Use Demo  
  
Exec sp_msforeachtable "ALTER TABLE ? ENABLE TRIGGER all"  

クエリ30:過去N日間に変更されたストアドプロシージャのリスト

SELECT name,modify_date  
  
FROM sys.objects  
  
WHERE type='P'  
  
AND DATEDIFF(D,modify_date,GETDATE())< N   

 

クエリ31:過去N日間に作成されたストアドプロシージャのリスト

SELECT name,sys.objects.create_date  
  
FROM sys.objects  
  
WHERE type='P'  
  
AND DATEDIFF(D,sys.objects.create_date,GETDATE())< N  

 

クエリ32:ストアドプロシージャを再コンパイルします

EXEC sp_recompile'Procedure_Name';  
  
GO  

クエリ33:テーブル上のすべてのストアドプロシージャを再コンパイルします

EXEC sp_recompile N'Table_Name';  
  
GO  

 

クエリ34:特定のデータ型のすべての列を取得します

SELECT OBJECT_NAME(c.OBJECT_ID) as Table_Name, c.name as Column_Name  
  
FROM sys.columns AS c  
  
JOIN sys.types AS t ON c.user_type_id=t.user_type_id  
  
WHERE t.name = 'Data_Type' 

クエリ35:テーブルのすべてのNullable列を取得します

SELECT OBJECT_NAME(c.OBJECT_ID) as Table_Name, c.name as Column_Name  
  
FROM sys.columns AS c  
  
JOIN sys.types AS t ON c.user_type_id=t.user_type_id  
  
WHERE c.is_nullable=0 AND OBJECT_NAME(c.OBJECT_ID)='Table_Name'  

クエリ36:主キーを持たないすべてのテーブルを取得

SELECT name AS Table_Name  
  
FROM sys.tables  
  
WHERE OBJECTPROPERTY(OBJECT_ID,'TableHasPrimaryKey') = 0  
  
ORDER BY Table_Name;  

クエリ37:外部キーを持たないすべてのテーブルを取得

SELECT name AS Table_Name  
  
FROM sys.tables  
  
WHERE OBJECTPROPERTY(OBJECT_ID,'TableHasForeignKey') = 0  
  
ORDER BY Table_Name;  

クエリ38:ID列を持たないすべてのテーブルを取得

SELECT name AS Table_Name  
  
FROM sys.tables  
  
WHERE OBJECTPROPERTY(OBJECT_ID,'TableHasIdentity') = 0  
  
ORDER BY Table_Name;   

クエリ39:今月の最初の日付を取得する

SELECT CONVERT (VARCHAR (25)、DATEADD(DAY 、-(DAY (GETDATE()))+ 1、GETDATE())、105)First_Date_Current_Month;   

 

クエリ40:前月の最終日を取得

SELECT CONVERT (VARCHAR (25)、DATEADD(DAY 、-(DAY (GETDATE()))、GETDATE())、105)Last_Date_Previous_Month;   

 

クエリ41:今月の最終日を取得する

SELECT CONVERT (VARCHAR (25)、DATEADD(DAY 、-(DAY (GETDATE()))、DATEADD(MONTH 、1、GETDATE()))、105)Last_Date_Current_Month;   

 

クエリ42:来月の最初の日付を取得する

SELECT CONVERT (VARCHAR (25)、DATEADD(DAY 、-(DAY (GETDATE()))、DATEADD(MONTH 、1、GETDATE())+ 1)、105)First_Date_Next_Month;   

クエリ43:2つの列の値を交換します

UPDATE  Table_Name  SET  Column1 = Column2、Column2 = Column1  

クエリ44:データベースからすべてのストアドプロシージャを削除します

Declare @Drop_SP Nvarchar(MAX)  
  
Declare My_Cursor Cursor For Select [name] From sys.objects where type = 'p'  
  
Open My_Cursor  
  
Fetch Next From My_Cursor Into @Drop_SP  
  
While @@FETCH_STATUS= 0  
  
Begin  
  
Exec('DROP PROCEDURE ' + @Drop_SP)  
  
Fetch Next From My_Cursor Into @Drop_SP  
  
End  
  
Close My_Cursor  
  
Deallocate My_Cursor  

クエリ45:データベースからすべてのビューを削除します

 Declare @Drop_View Nvarchar(MAX)  
  
Declare My_Cursor Cursor For Select [name] From sys.objects where type = 'v'  
  
Open My_Cursor  
  
Fetch Next From My_Cursor Into @Drop_View  
  
While @@FETCH_STATUS = 0  
  
Begin  
  
Exec('DROP VIEW ' + @Drop_View)  
  
Fetch Next From My_Cursor Into @Drop_View  
  
End  
  
Close My_Cursor  
  
Deallocate My_Cursor  

クエリ46:すべてのテーブルを削除する

EXEC sys.sp_MSforeachtable @command1 = 'Drop Table ?'  

クエリ47:テーブルの列の情報を取得する

SELECT * FROM INFORMATION_SCHEMA.COLUMNS  
  
WHERE INFORMATION_SCHEMA.COLUMNS.TABLE_NAME=’Table_Name’  

クエリ48:制約を含むすべての列を取得する

SELECT  TABLE_NAME、COLUMN_NAME、CONSTRAINT_NAME  FROM  INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE  

クエリ49:ビューを含むすべてのテーブルを取得します

SELECT  *  FROM  INFORMATION_SCHEMA.VIEW_TABLE_USAGE  

クエリ50:ビューで使用しているテーブルのすべての列を取得します

SELECT  *  FROM  INFORMATION_SCHEMA.VIEW_COLUMN_USAGE  

リンク: https://www.c-sharpcorner.com/article/50-important-queries-in-sql-server/

#sql 

Ananya Gupta

1613386017

Key Points For Joining The Best Web Designing For Better Career Option

The scope of the web designer is increasing day by day, because of high demanding job forms an important part of our society. Web Designing is that the creation and planning of internet sites. it’s a process of developing different sites.

To be an honest web designer you ought to have an entire knowledge of CSS and HTML. These are the important prerequisite for designing an internet site. In today’s world of competition to be amongst at the highest one needs media. Websites are playing a key role in today’s life. Whether in online web desiging course mention shopping or engineering everything is formed online.

These are some of the main benefits which a standard person has made with the utilization of internet sites. many roles are available for web designers than before. Many big companies demand experienced and quality web designers.

Web designing is the creative and innovative part of web development during which the designer is especially concerned with how our website looks. CSS is the heart of the web designing part.

The scope of web designing is increasing day by day. In today’s web and internet world, people want a creative website once they want to access it. Top company web development of India hands over 8-10 lac per annum for an experienced web designer. So it’s a really good field for creating websites.

Web designers have the work of designing whole websites which forms the primary step of web development. After web designing remaining work will start. In today’s growing scenario there are many job opportunities for fresher and experienced candidates.

Web designing is a crucial course that features a lot of scope within the present and also in the future scenario. There are two ways to travel through this course. If you’re curious about taking over a full-time web designer course then we will make a career in media or as advertising agents.

If one is curious about Engineering or in Commerce course but getting to develop the skill in web designing, then you’ll prefer the part-time short course in web designing.

When it comes to selecting a training institute, you will find them in every corner. CETPA Infotech is a reputed training institution and provides training that is industry oriented, updated, innovative and summer training has become a pioneer during this online designing field.

#web designing training in noida #web designing training in delhi #web designing online training #web designing online course #web designing course #web designing training

Sunny Joshi

1626433760

Best Web Development Institute in Delhi - Online Course

If you want to pursue a career in Web Development, then you must opt for a Web Development course in Delhi. The Best Web Development Institute in Delhi is offered by Web Development colleges or institutions. They are designed to give you the necessary training to start a Web Development company or a web design business. These courses are generally provided by Techstack and other institutes in Delhi like APTRON, ADMEC, Next G Education etc. contact them and get the best online training in India. These institutes offer the basic courses with advanced level of courses.

Their courses help you learn Web Development and web marketing. The Best Web Development Institute in Delhi will enable you to understand the basic requirements of web design and Web Development. You can also enhance your web design skills through these Web Development courses in Delhi. The Web Development training in Delhi from an experienced Web Development institute in India will teach you Web Development principles and methods through their live projects. This course in Delhi from an institute of good repute has a host of practical, theoretical and educational lessons which can be followed closely. These Web Development training institutes in Delhi can be followed up with classroom learning.

Best Web Development Institute in Delhi:

The institute, which you select for training in Delhi can decide the schedule of classes. Some Web Designing institutes provide you with the opportunity of choosing a particular institute for online training also. In this case, you would be able to find Web Development courses in Delhi conducted by that institute. The course work of these institutes is generally taught in a classroom setting. Most of these institutes conduct both classroom sessions and web-based courses.

You can take Web Development training in Delhi from an institute which offers you real world-class online training. The Techstack Academy conducts its Web Development training in a traditional manner. Students can create their own applications using the modern lab environment provided at the best institute. Many institutes conduct their web-based online course in a modern lab setup. They have a number of modern labs where students can interact with their teachers and fellow students of the same institute. This interaction helps the students identify and grasp concepts in an easy manner.

In the Web Development training in Delhi from an institute of good repute, students can choose between Web Development with live projects, web design and Web Development with prototypes with manual coding. The students can choose the best course for them depending on their goals and preferences.

Also Read: Web Development Course in Delhi (#1 Best Training Institute)

With regard to Web Development training in Delhi, the first step that the students have to take is to register themselves at the Best Web Development Institute in Delhi of their choice. Once they are registered, they can choose the course of their choice. Some of these training centers offer intensive training while some do not offer any specialised training and hence students can easily find an online training institute in Delhi NCR also that suits their needs.

In order to get a web designing course in Delhi, one has to follow certain rules. First of all, the students need to contact the Web Development training centre in Delhi and register themselves for the course. The Best Web Development Institute in Delhi may conduct an interview process or conduct a web-course interview. The institute needs to understand the skills that the student possesses. Students can look forward to a bright career in web designing courses in Delhi as they can secure a number of jobs after completing their courses.

#web designing course in delhi #web development institute in delhi #web development training in delhi #web development course #web development institute #best web development institute in delhi