[T-SQL Tuesday] Data modeling: The trouble with prefixes
This month, Mickey Stuewe (b|t) hosted T-SQL Tuesday, giving us a topic of “data modeling gone wrong“. This is a fantastic...
2015-11-23 (first published: 2015-11-17)
2,137 reads
Blog Posts
Calculating Table Partition Sizes in Advance
[read this post on Mr. Fox SQL blog] Continuing on with my Partitioning post series, this is part 7. The partitioning includes several major components of work (and can be linked...
2015-11-23
10 reads
Create stub tSQLt tests in SSDT from stored procedures
I have released another tool as part of the ssdt dev pack, what this does is create tSQLt classes and...
2015-11-23 (first published: 2015-11-17)
2,223 reads
Cumulative update package 9 for SQL Server 2012 SP2
Microsoft just announced Cumulative update package 9 for SQL Server 2012 SP2
Microsoft reference: [Click Here]
For more updates:
Subscribe for Blog posts [Click Here]
Follow...
2015-11-23
140 reads
Steps to install SQL Server CTP 3 on Windows Azure
Hi friends, SQL Server 2016 CTP 3 is available now and it can be downloaded on Azure. So I tried...
2015-11-23
502 reads
My PASS Summit 2015 Recap
A few days ago I returned from PASS Summit 2015 (and a vacation I took afterwards). Here’s my recap: I...
2015-11-22
679 reads
SSDT DevPack - Highlight expensive queries
When developing stored procedures in SSDT it is important to know when you have written a query that is potentially...
2015-11-22
28 reads
SSDT DevPack - Highlight expensive queries
When developing stored procedures in SSDT it is important to know when you have written a query that is potentially...
2015-11-22
78 reads
SSDT DevPack - Highlight expensive queries
When developing stored procedures in SSDT it is important to know when you have written a query that is potentially...
2015-11-22
18 reads
SSDT DevPack - Highlight expensive queries
When developing stored procedures in SSDT it is important to know when you have written a query that is potentially slow or has a high IO or CPU cost...
2015-11-22
9 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