Weekly Roundup–SQL Server and Related News
Welcome to this weeks weekly round up of links, SQL Server and other news. Its been a busy week on...
2016-04-05
408 reads
SQL Server PerfMon Counters Not Listed in dm_os_performance_counters
Had an issue with a new Azure VM install of SQL Server, but have had this issue in other, older...
2016-04-05
1,490 reads
Locking sa
When I started working with SQL Server, the sa account was “the” account used for admin operations. This was the...
2016-04-04
1,043 reads
Don't Use Delimiters In Your Object Names!
It started with a failed backup status check:
Msg 50000, Level 16, State 1, Line 73
** Backups listed in this file...
2016-04-04
2,285 reads
MongoDB – Calculating Document Size
We can get the size of a document is by using the shell’s Object.bsonsize() function.We pass the object_id of the document...
2016-04-04
539 reads
#SQLNewBlogger–Adding Local Accounts
What do you do if you need a process running under Local Service to connect to your SQL Server? Most...
2016-04-04
652 reads
Monday Morning SQL Break – April 4, 2016
It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me...
2016-04-04
461 reads
Complex/Conditional ORDER BYs
Typically it’s considered best to run your queries without an ORDER BY and let the application do any sorting needed....
2016-04-04
482 reads
Use PowerShell to script existing Availability Group creation scripts!
Scripts that write scripts! One of my favorites!
So last night I was up working on an issue with an Availability...
2016-04-07 (first published: 2016-04-04)
7,609 reads
SSC Editorial: Is Powershell Intimidating?
Is Powershell intimidating? It’s an interesting question, though perhaps unfair – TSQL can be intimidating when you first start out too....
2016-04-04
526 reads
Blogs
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Forums
"Click" your SQL Server into an MCP agent, with RBAC and full security
Hi guys and gals, I've created a system that automatically allows you to "generate"...
Demo Tracking Dropped Objects
Comments posted to this topic are about the item Demo Tracking Dropped Objects
Randomly Selecting Columns and Rows from a Table or View
Comments posted to this topic are about the item Randomly Selecting Columns and Rows...
Question of the Day
Getting Database MaiL Profiles
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers