SQLIntersection conference wrapup
Two weeks ago was a busy one. I helped coordinate and spoke at our second SQL Saturday Omaha on April...
2013-04-25
800 reads
5 SQL Server White Papers Every DBA Should Read
There are countless sources for information on SQL Server available today. There are books, webcasts, conferences, and blogs. With all...
2013-04-25
861 reads
Consultants – Why pay more?
As an independent consultant who has a higher bill rate than average, I would hope it is obvious to clients that the...
2013-04-25
1,422 reads
SQL Lunch – GeoFlow: 3D Geospatial Visualization
Join me next month to learn about a new Geospatial visualization feature of Excel 2013 on the SQL Lunch.
Lunch Details
#75-GeoFlow:...
2013-04-25
1,440 reads
Adding Data to Filestream with T-SQL
I’ve written on how to enable Filestream and how to add a filegroup, but I haven’t touched the Filestream impact...
2013-04-25
1,379 reads
Database Administration KPIs – 1/2
As a DBA, we may all have this question: How should my work be evaluated objectively? or in another way,...
2013-04-25
526 reads
Database Administration KPIs – 1/2
As a DBA, we may all have this question: How should my work be evaluated objectively? or in another way,...
2013-04-25
3,546 reads
How to backup a SQL 2012 database directly to Windows Azure
It has been a little while since I posted something and I’ve been meaning to finish off this blog for...
2013-04-24
1,926 reads
PowerSQL – Generate Only Index Script of All Tables or Specific Tables
Background of this implementation-As a part of Performance tuning, We noticed huge avg_disk_queue_length on F drive after analysis, we’ve recommended to...
2013-04-24
850 reads
Identify the cause of SQL Server blocking
In my previous article (Different techniques to identify blocking in SQL Server) on MSSQLTips.com, I discussed about locks and blocks,...
2013-04-24
904 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