Agent Jobs Using SSIS
This is a short script to help the DBA with documentation purposes. This would come in handy especially in those...
2012-03-15
860 reads
Cached blocking history with sys.dm_db_index_operational_stats
Transactions generate IO, latching and locking on tables and indexes , while attempting to access data. The sys.dm_db_index_operational_stats DMV returns aggregated data...
2012-03-15
1,366 reads
SQL Server 2012 Performance Test: Truncate a Date/Time to Different Parts
SQL Server 2012 introduces several new date/time functions that allow you to build a date/time from the individual parts of...
2012-03-15
2,980 reads
Importing images to SQL server database using T-Sql
Yesterday evening one of the developer asked me that he need a help in importing images into a table. It...
2012-03-15
11,527 reads
Webcast: What Are You Waiting For?
What was the number one question from today’s webcast on wait statistics? Where can the slides and sample code be...
2012-03-15
745 reads
Ownership Chains in SQL Server
Someone asked the question recently about allowing a user to run a process,but not execute the individual pieces of the...
2012-03-14
4,209 reads
SQL Server 2012: Tabular Models vs PowerPivot Models
In SQL Server 2012, there is a new data model, called tabular, that is part of the new feature called the...
2012-03-14
2,791 reads
Creating cards in Trello via the REST API and parsing the returned JSON all in a SQL CLR
I recently blogged about how good I thought Trello was and shortly afterwards I found out that they did provide...
2012-03-14
8,615 reads
Understanding the concept of SQL Server Failover Cluster
Before getting hands on experience in SQL server on failover cluster , I used to read many article about failover clustering. Unfortunately...
2012-03-14
17,398 reads
How Resilient Is Your Recovery Plan?
In this modern age of technology DBA’s face an ever increasing demand from businesses; our databases must perform, be secure,...
2012-03-14
626 reads
Blogs
Fighting Procrastination?
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
A Fun Prize at the PASS Data Community Summit
By Steve Jones
I had a briefing for the 2026 PASS Data Community Summit, which is just...
How to Measure AI Value: A 6-Branch AI Maturity Model for Use Cases and Agents
Your AI is busy. But do you know what it's worth? Most companies can...
Forums
Inventory Snapshot for missing Period
Hello, We maintain an inventory table that captures monthly snapshots of item inventory levels....
Azure SQL Hyperscale Unveiled
Comments posted to this topic are about the item Azure SQL Hyperscale Unveiled
What is the worst part about existing monitoring solutions?
Hi. What is the most difficult aspect of using monitoring software like idera, redgate,...
Question of the Day
SQL Server Vector Support I
What are vectors in SQL Server 2025, as related to the new AI features?
See possible answers