Monday Morning SQL Break – September 19, 2016
It’s Monday and time for this week’s blog and twitter round-up. It’s been a few weeks since the last recap,...
2016-09-19
951 reads
Blog Posts
North Texas SQL Server User Group – September 2016 Follow
Thanks for attending my presentation on window functions in TSQL during the September 15, 2016. I hope you learned something you...
2016-09-19
399 reads
Setting DBCC 1222 on startup
The following command is run to gain details on deadlocks.
DBCC TRACEON (1222,-1)However, once the SQL instance is restarted this flag...
2016-09-19
148 reads
Speaking at Suburban Chicago SQL Server Users Group Tomorrow
I will be presenting a technical session entitled ‘Virtual SQL Servers. Actual Performance‘ tomorrow evening for the Suburban Chicago SQL Server Users...
2016-09-19
363 reads
The Clustered Index Is Vital To Your Database Design
This is post #9 supporting Tim Ford’s (b|t) initiative on #iwanttohelp, #entrylevel. Read about it here.
You get one clustered index per table.
That...
2016-09-19 (first published: 2016-09-12)
2,514 reads
Migrating to Azure SQLDatabase
Right now one of the hottest topics around the world is the cloud and the successful methods for the migration...
2016-09-18
706 reads
"SQL Server Permissions and Security Principals" at SQLSaturday #560 Charlotte 2016
I'm proud to have been a part of SQLSaturday Charlotte 2016 this year, and happy that I was joined by...
2016-09-17
365 reads
Load Testing Results Might Not Be What You Think
Bottlenecks in your testing tools, infrastructure, or methodology might just hurt your load test results, and the results can skew...
2016-09-16 (first published: 2016-09-12)
1,323 reads
Open Source PowerShell – Play by Play
What’s going on here? So last week you may have seen this picture on Twitter…it went a little crazy…and you may have been wondering what are we up to?...
2016-09-16
19 reads
SQL Sentry Plan Explorer is now free
You’ll probably hear about this from other sources, but an announcement made this morning bears repeating: One of my favorite...
2016-09-16 (first published: 2016-09-09)
2,716 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...
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...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
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