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
348 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,748 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
278 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
330 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
21 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
10 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
648 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
408 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
15 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
20 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Hyperscale Replicas IV
Comments posted to this topic are about the item Hyperscale Replicas IV
The SQL Server Date Magic: When CAST and CONVERT Keep Your Index Seek
Comments posted to this topic are about the item The SQL Server Date Magic:...
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers