SQL Server Management Studio 18.0 is available now.
SSMS 18.0 is available for download now.Microsoft has released the new version of SSMS, the free client tool from Microsoft to manage to the SQL Server infrastructure from SQL...
2019-04-29
Ganapathi's MSSQLLover
Difference Between Restore with Recovery & Restore with Norecovery
Every tech-conscious person is familiar with restoration process in the world of computing. This process is usually followed by the...
2018-12-13
37,117 reads
Difference Between Restore with Recovery & Restore with Norecovery
Every tech-conscious person is familiar with restoration process in the world of computing. This process is usually followed by the process of backup. In case of SQL Server, restoration...
2018-12-13
33 reads
Calculating DTU's for Azure SQL Database
One of my clients asked to calculate the DTU’s required for an existing database before migrating to Azure SQL Database....
2018-03-05
590 reads
Calculating DTU's for Azure SQL Database
One of my clients asked to calculate the DTU’s required for an existing database before migrating to Azure SQL Database. Pricing Azure SQL Database is different from traditional SQL...
2018-03-05
1 reads
Configure Read only routing for an always on availability group
One of my friend sent an email with the requirement to load balance the traffic coming from application to secondary...
2018-03-05
575 reads
Configure Read only routing for an always on availability group
One of my friend sent an email with the requirement to load balance the traffic coming from application to secondary SQL Server replicas in always on availability group. Read-only...
2018-03-05
5 reads
How to Change the File Extension for a Data File
Link Below:
How to Change the File Extension for a Data File
In general, the file extensions for our SQL Data Files...
2018-01-11
362 reads
How to Change the File Extension for a Data File
Link Below:
How to Change the File Extension for a Data File
In general, the file extensions that we use for SQL Server data files are MDF (Primary Data File), NDF...
2018-01-11
2 reads
Changing the Path for the Master Database
Link Below:
Changing the Path for the Master Database
This article will show how we can move the master database to a...
2018-01-11
336 reads
Blogs
Extended Events in Azure Data Studio
I know I can use extended events (xevents) in Azure SQL DB when in...
Azure Workbooks
I’m saddened that the Workspace Summary is being deprecated in Log Analytics Workspace. I...
SQL Prompt Tips–Using $surroundtext$ in a Snippet
By Steve Jones
A user on the SQL Community Slack was asking about what the $surroundtext$ variable....
Forums
Reduction of installation time of sql server 2008 R2 Express
The installation of SQL Server 2008 R2 Express on a virtual machine takes around...
Creating Aggregates
Comments posted to this topic are about the item Creating Aggregates
Getting Started with DDL statements of Cassandra Query Language
Comments posted to this topic are about the item Getting Started with DDL statements...
Ask SSC