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,043 reads
A Rickety Stairway to SQL Server Data Mining, Part 12: Accessing SSDM with AMO, ADOMD, SSIS, XMLA and RS
by Steve Bolton
It may set a SQLServerCentral record for the thickest alphabet soup of acronyms ever crammed into a...
2013-05-09
2,622 reads
Book Review: Business in the Trenches
I’m trying to improve.
That’s at just about everything too. I know I don’t know enough or have enough skills to...
2013-05-09
736 reads
Blogs
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...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
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