MSSQLTIPS SQL Server Webcast
MSSQLTIPS offers new webcast monthly. Topics in various areas of SQL Server are covered and perfect for all DBAs out...
2013-07-12
425 reads
Deleting a Storage Account from Windows Azure – The right way !
I like to clean up things after I’m done with my testing and this morning I decided to clean up...
2013-07-11
1,992 reads
PowerShell – Get CPU Details and its Usage
This PowerShell script helpful in finding No of Processors, Speed and It’s current usage based on samples being gathered at...
2013-07-11
1,668 reads
Test Your Restores
Test your restores: he first tip in my Hard Earned Lessons of a DBA piece.
I can’t emphasize this enough. I’ve...
2013-07-11
834 reads
I’ll take “Products that start with Power”, Alex
FYI:
Geoflow (see Geoflow Preview for Excel 2013) is now called Power Map, and Data Explorer (see Microsoft Data Explorer) is now called...
2013-07-11
892 reads
Security Questions: Server Role Tips
As I mentioned in the introductory post, during the Introduction to SQL Server Security session for Pragmatic Work’sTraining on the T’s, I...
2013-07-11
565 reads
SQL Server Diagnostic Information Queries for July 2013
Reblogged from Glenn Berry's SQL Server Performance: I have gone through and made some minor updates and bug fixes for...
2013-07-11
354 reads
Access denied on your SSIS SQL Server 2008
Scenario. You have a new SSIS server. All DTS packages migrated and deployed successfully to this new SSIS server. You send...
2013-07-11
348 reads
SQL Server: All About SQL Server Statistics : Consolidated post
Statistics is the one of the important factor which helps the optimizer to choose the right execution plan.At the same time, many of us (so called DBA) will not...
2013-07-11
49 reads
SQL Server: All About SQL Server Statistics : Consolidated post
Statistics is the one of the important factor which helps the optimizer to choose the right execution plan.At the same...
2013-07-10
972 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