SQL Server Find Unused Data Files
You know that old SQL Server you’ve left running the last 5 years and had numerous databases dropped and restored...
2018-12-06
706 reads
Gavin Draper
Live Query Stats of Running Queries
Since SQL Server 2014 SP1 we’ve had DMV’s that can support Live Query Statistics (Basically a query plan that gives...
2018-11-24
254 reads
Why Wont SQL Server Use My Filtered Index?
As with most of my posts of late all examples here are using the StackOverflow SQL Server database that can...
2018-10-02
249 reads
Why Wont SQL Server Use My Filtered Index?
As with most of my posts of late all examples here are using the StackOverflow SQL Server database that can...
2018-10-02
130 reads
Missing Index Recommendations, These Are Not The Indexes You’re Looking For
Picture the scene….. DBA Doug is sitting in his cubicle minding his own business when App Dev Allister gives him...
2018-09-29
150 reads
Missing Index Recommendations, These Are Not The Indexes You're Looking For
Picture the scene….. DBA Doug is sitting in his cubicle minding his own business when App Dev Allister gives him...
2018-09-29
177 reads
SQL Server How to Check What Settings Are Set On Active Sessions
SQL Server has a number of settings set on a session that can influence the behaviour or queries. When debugging...
2018-06-01
241 reads
SQL Server How to Check What Settings Are Set On Active Sessions
SQL Server has a number of settings set on a session that can influence the behaviour or queries. When debugging...
2018-06-01
125 reads
SQL Server Minimally Logged Inserts (Assume Nothing!)
Side note : I originally started this post to show with examples all the scenarios where you can get minimal logging...
2018-05-29
155 reads
SQL Server Minimally Logged Inserts (Assume Nothing!)
Side note :
I originally started this post to show with examples all the scenarios where you can get minimal logging...
2018-05-29
186 reads
Blogs
Wait… Could This Be the End of Index Maintenance?
While attending SQLCon and FabCon Europe in Barcelona, there were a lot of announcements...
Copilot on the Power BI Report Canvas vs. Modern Report Builder
By James Serra
(This is the second post in a three-part series on how AI is changing...
The #MS_DatabaseConnector## Role: #SQLNewBlogger
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Layanan Resmi BCA KCU CIANJUR Telp:0817°825°533
Telp/Wa 62817825533 Jl. HOS Cokro Aminoto No.56-58, Muka, Kec. Cianjur, Kabupaten Cianjur, Jawa Barat...
Layanan Resmi BCA KCU DEPOK Telp:0821°7555°651
Telp/Wa 628217555651 Jl. Margonda Raya No.182, Kemiri Muka, Kecamatan Beji, Kota Depok, Jawa Barat...
Question of the Day
The ##MS_DatabaseConnector## User
On SQL Server 2025, I run this code as a sysadmin:
CREATE LOGIN Demo WITH PASSWORD = 'Demo1234567' GO ALTER SERVER ROLE ##MS_DatabaseConnector## ADD MEMBER Demo GOI then login as Demo and run this:
USE sandbox go SELECT CURRENT_USERWhat is returned? See possible answers