The new SQL Server Management Studio 2016
The installation of SSMS 2016 is different and it’s a separate installation. It’s not a part of the SQL Server installation as it was the case until SQL Server 2014....
2016-05-24
6 reads
Database Restore Fails with Msg 3154
Have you ever tried to restore over an existing database only to receive the following error message?
Msg 3154, Level 16,...
2016-05-24
846 reads
The new SQL Server Management Studio 2016
The installation of SSMS 2016 is different and it’s a separate installation. It’s not a part of the SQL Server installation...
2016-05-24
228 reads
Live execution plans
SQL Server 2016 brings one of the new features – The live execution plan. You can enable it by clicking the highlighted icon on the Toolbar. Then running a query...
2016-05-24
4 reads
Live execution plans
SQL Server 2016 brings one of the new features – The live execution plan. You can enable it by clicking the highlighted icon on the Toolbar. Then running a query...
2016-05-24
9 reads
Live execution plans
SQL Server 2016 brings one of the new features – The live execution plan. You can enable it by clicking the...
2016-05-24
176 reads
SQL Server 2016 NYC Launch Event - Tickets Running Out!
In a previous blog, I spoke about the upcoming RTM Launch of SQL Server 2016 - Get Ready! Microsoft is ready...
2016-05-24
1,338 reads
SQL Server – Conditions when value of @@error changes
Hi friends, when we do error handling in our SQL code we use different methods like TRY/CATCH, RAISERROR etc. to...
2016-06-02 (first published: 2016-05-24)
1,367 reads
PowerShell : Scripting Logins, Role Assignments and Server Permissions Using PowerShell
This post is a continuation of Multiple DB refresh automation using PowerShell post . The OP requested me to automate the...
2016-05-23
721 reads
SQL Server on VMware Workshop at VMworld
I am extremely proud to announce my participation in the inaugural SQL Server workshop at this year’s VMworld US in Last...
2016-05-23
395 reads
Blogs
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
Forums
How Can SQL Server Detect Application Errors When Developers Can’t?
Comments posted to this topic are about the item How Can SQL Server Detect...
Getting Database MaiL Profiles
Comments posted to this topic are about the item Getting Database MaiL Profiles
Preserving Data
Comments posted to this topic are about the item Preserving Data
Question of the Day
Getting Database MaiL Profiles
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers