Dragging a name from the object explorer to a query window
In the same vein as Steve Jones’ series on Customizing SSMS this is a fairly basic trick, but one that...
2013-05-16 (first published: 2013-05-13)
3,855 reads
DMV-10 : Does my database contain edition specific features?……..sys.dm_db_persisted_sku_features
sys.dm_db_persisted_sku_features (Introduced in SQL Server 2008) DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-in/library/cc280724.aspx
Some features of the SQL...
2013-05-13
2,095 reads
Security Questions: What permissions are required to create temporary tables?
As I mentioned in the introductory post, in the Introduction to SQL Server Security session for Pragmatic Work’sTraining on the T’s, I...
2013-05-12
761 reads
Database Assessment
This script looks much more intimidating than the results it produces, so I recommend running it before reading through it. ...
2013-05-11
478 reads
Non-Tech Books On My Desk
This post is inspired by Andy Warren’s ( b | t ) “Books On The Desk” post.
I’ve got plenty of SQL Server books...
2013-05-10
924 reads
Reblog: May 3 to May 9
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-05-10
570 reads
2013-05-10
411 reads
Schizophrenic Windows 8
I’ve been using Windows 8 almost exclusively for about 3 weeks. I got a new desktop a couple months back,...
2013-05-10
1,023 reads
Drafting Email You’ll Never Send-Probably
It’s not uncommon to get frustrated about something at work and send out an email blasting whatever person or group...
2013-05-10
707 reads
Speaking in Columbia and Charlotte Next Week
I'm speaking at two user groups next week.
Tuesday - Midlands PASS - May 14
I'll be giving a presentation on PowerShell to help...
2013-05-10
1,044 reads
Blogs
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Cleaning Up My Blog's SEO and AEO with Claude in GitHub Copilot
I’ve been running this blog on Hugo for a long time, and like most...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers