Connect to SQL Azure database from SSMS
In this article I'll show you how to connect to SQL Azure database instance and create a simple database. First you have...
2016-06-17
327 reads
Igor Micev
Two new authentication options in SSMS 2016
Until SSMS 2014 there were the two standard authentication options for connecting to a SQL Server instance: Windows Authentication and...
2016-06-14
4,744 reads
The CHECK constraints unlike behaviours
The CHECK constraints enforce integrity by limiting the values that are accepted by one or more columns. You can create...
2016-06-13
275 reads
The CHECK constraints unlike behaviours
The CHECK constraints enforce integrity by limiting the values that are accepted by one or more columns. You can create...
2016-06-13
318 reads
The CHECK constraints unlike behaviours
The CHECK constraints enforce integrity by limiting the values that are accepted by one or more columns. You can create a CHECK constraint with any logical expression that returns...
2016-06-13
12 reads
The CHECK constraints unlike behaviours
The CHECK constraints enforce integrity by limiting the values that are accepted by one or more columns. You can create a CHECK constraint with any logical expression that returns...
2016-06-13
4 reads
The COUNT function in T-SQL
The COUNT function is among the most used functions in the T-SQL codes. Even though COUNT is easy to use, it...
2016-06-11
635 reads
The COUNT function in T-SQL
The COUNT function is among the most used functions in the T-SQL codes. Even though COUNT is easy to use, it...
2016-06-11
395 reads
The COUNT function in T-SQL
The COUNT function is among the most used functions in the T-SQL codes. Even though COUNT is easy to use, it should be used carefully because it could often not...
2016-06-11
6 reads
The COUNT function in T-SQL
The COUNT function is among the most used functions in the T-SQL codes. Even though COUNT is easy to use, it should be used carefully because it could often not...
2016-06-11
11 reads
Blogs
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
Increase Deadlock Detection
Comments posted to this topic are about the item Increase Deadlock Detection
A Tool is Better than a Script
Comments posted to this topic are about the item A Tool is Better than...
Understanding Deadlock Victim Selection in SQL Server
Comments posted to this topic are about the item Understanding Deadlock Victim Selection in...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers