Scaring a Database Near you
Something I have a hard time by-passing is a good R2 unit. I have R2 units in so many different forms, including a standing R2 cake one year for...
2013-10-31
9 reads
Blog Posts
Scaring a Database Near you
Something I have a hard time by-passing is a good R2 unit. I have R2 units in so many different...
2013-10-31
1,278 reads
SQL Server Data Tools for SQL Server 2014 CTP2 now available
From Microsoft, SSDT is now available for SQL Server 2014:
We’d like to announce the availability of SSDT that supports SQL...
2013-10-31
1,584 reads
SSIS Pivot on bad data
The pivot transform in SSIS is already a pain to use. When you have bad data it makes it even...
2013-10-31 (first published: 2013-10-28)
1,800 reads
Tales from the Query Processor: II
Hello Dear Reader! Today is Halloween, October 31st. My Daughter turns a big 15 today! Happy Birthday Ches!!!!!
To celebrate two...
2013-10-31
1,385 reads
To DBA or Not to DBA…
In my day to day operations I have the opportunity to work with people in various capacities in regards to data. Sometimes it is in the capacity of a...
2013-10-31
8 reads
To DBA or Not to DBA…
In my day to day operations I have the opportunity to work with people in various capacities in regards to...
2013-10-31
1,243 reads
First take on PowerPivot
What is PowerPivot for Excel? PowerPivot brings the power of Data Modelling into your PC. Traditionally, the DataWarehouse is built...
2013-10-30
1,664 reads
I’m Attending SQLSaturday #248 in Tampa on Nov 9, 2013
I’ll be heading back to Tampa on November 9, 2013 for the BI Edition of SQLSaturday. I’ll be presenting PCI...
2013-10-30
1,201 reads
Interview With Rick Bolesta of the PASS Board of Directors
Rick Bolesta and Neil Buchwalter of CA technologies are leaving the Board at the end of 2013. CA and Microsoft...
2013-10-30
1,426 reads
Blogs
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
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...
Forums
Practical Ways to Approach SQL Server Problems and Case Studies
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Importing Excel files into SQL Server using DuckDB and Python
Comments posted to this topic are about the item Importing Excel files into SQL...
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers