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
9 reads
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
43,646 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
50 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
608 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
8 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
627 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
11 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
383 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
3 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
342 reads
Blogs
PASS: Quantum Computing Slides
By Brian Kelley
If you're an attendee at the PASS Data Community Summit this year, there are...
A New Word: Dead Reckoning
By Steve Jones
dead reckoning– v. intr. finding yourself bothered by somebody’s death more than you would...
PASS Data Community Summit 2025 Slides and Code
By alevyinroc
Thank you for attending my PASS Summit 2025 session Answering the Auditor’s Call with...
Forums
Personal Contact Is Vital
Comments posted to this topic are about the item Personal Contact Is Vital
Getting the Schema for Tables
Comments posted to this topic are about the item Getting the Schema for Tables
An Unexciting Exciting Release
Comments posted to this topic are about the item An Unexciting Exciting Release
Question of the Day
Getting the Schema for Tables
What happens when I run this on SQL Server 2022 in the AdventureWorks2022 database?
SELECT OBJECT_DEFINITION (OBJECT_ID(N'Person.Person')) AS [Object Definition]; GOSee possible answers