My Writing Toolkit for the book project
I’m in the middle of writing the first chapter of my book. I’m not just ready to announce the working...
2012-12-05
843 reads
Blog Posts
Next Chennai SQL Server UG Meet Is Scheduled
Chennai SQL Server user group meet is scheduled for Dec'2013.
Venue: Microsoft Training Centre, Radhakrishnan Salai, Chennai
Landmark: Opposite to President hotel
Timing: 09:30...
2012-12-05
1,591 reads
Plan cache bloat by SQLAgent (Prior to SQL2008) !
Recently I was checking the plan cache utilization with the help of the below query which I normally use for...
2012-12-05 (first published: 2012-11-29)
2,458 reads
About
I am a geek, husband, father, geocacher & gratuitous consumer of satellite signals (not in that order). I’ve been in IT professionally for over two decades doing web development,...
2012-12-04
5 reads
Backup History
This is a quick rewrite of the script I just posted a few days ago. The script had a few...
2012-12-04 (first published: 2012-11-30)
2,517 reads
Get Performance Counters from within SQL Server
I think most DBAs know that you can use the Windows Performance Monitor to capture performance metrics for your SQL...
2012-12-04
907 reads
How to create site directly in new content db
Hey Friends,
Sometime when we build a new SharePoint site or site collection. We may feel to create in a new...
2012-12-04
382 reads
On the Advantages of DateTime2(n) over DateTime
Starting with SQL 2008, we database developers started becoming more familiar with datetime2. Sometimes folks need convincing though, so here...
2012-12-04
12,264 reads
SQL Server Policy Based Management Alerts
SQL Server Policy Based Management Alerts
Problem
Policy-Based Management is used to enforce standards on SQL Servers and it's great. But not...
2012-12-04
4,335 reads
HDInsight, Finally
See this:
That’s right. The install worked. All I had to do was get a completely clean server set up. No...
2012-12-03
1,381 reads
Blogs
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...
Cultural Change: Fostering a Cost-Aware Culture in Your Organisation
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
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