April 2013 – Monthly SQL Server Checklist
After working on this monthly checklist for over a year, I’ve recently discovered that there isn’t anything that we should...
2013-04-01
548 reads
Blog Posts
DMV-3 : What is currently going on ?……..sys.dm_exec_requests
sys.dm_exec_requests DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-us/library/ms177648.aspx
Returns information about each request that is executing within SQL...
2013-04-01
1,193 reads
Last Weeks Top “Reading” Links #26
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-04-01
437 reads
Mo-SQL On A Stick
If you’re involved in the database world it’s hard to have missed the rise of the “no-sql” database products, designed...
2013-04-01
1,022 reads
Setup SSL Access to SSRS 2012 with Active Directory Certificate Services
The objective was to configure SSL access to a SQL 2012 Reporting Services server in Native Mode. The Certificate Issuer...
2013-04-01
12,426 reads
SQL Server Analysis Services Webinar
Join me tomorrow, April 2. 2013, at 11:00 PM EST for a free webinar which is part of an entire...
2013-04-01
860 reads
Custom Reports for SSMS 2012
I presented on this topic at the TriadSQL User’s Group meeting on 3/26/13. I promised I would post my code/solutions,...
2013-03-29
2,151 reads
Exploring Excel 2013 for BI Tip #5: Cleaning Up Slicers
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2013-03-29
1,599 reads
Free SQL Server Training for the Week of April 1, 2013
Here are some training events you might be interested in for the coming week:
Tuesday, April 2
11:00-12:00 EDT, Introduction to SQL...
2013-03-29
1,599 reads
PowerShell Usage in DBA Work – Case Study 7/7
Reading/scanning SQL Server Logs is a required DBA work item in all my work environments. I know there are lots...
2013-03-29 (first published: 2013-03-24)
2,603 reads
Blogs
The Intersection Between DevOps and FinOps
By HeyMo0sh
DevOps is about shortening the system development lifecycle. Plan faster, build faster, test faster,...
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Forums
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Working Better Under Pressure
Comments posted to this topic are about the item Working Better Under Pressure
Identities and Sequences V
Comments posted to this topic are about the item Identities and Sequences V
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers