ScriptDom Visualizer
Writing code to generate TSql using the ScriptDom is hard. There is a seemingly bewildering array of objects you can...
2015-11-03
17 reads
ScriptDom Visualizer
Writing code to generate TSql using the ScriptDom is hard. There is a seemingly bewildering array of objects you can...
2015-11-03
28 reads
Goodness-of-Fit Testing with SQL Server, part 2.1: Implementing Probability Plots in Reporting Services
By Steve Bolton
…………In the first installment of this series of amateur self-tutorials, I explained how to implement the most basic...
2015-11-03
1,298 reads
A Mess of Nested Transactions
Transactions are an area that I often find are used badly, or not used at all. Transactions without any error...
2015-11-03
851 reads
DLM Dashboard moves to 50 Databases – For FREE
I love DLM Dashboard. It’s the product that I’ve written myself, in various ways since SQL Server 6.5. My versions...
2015-11-03
742 reads
PASS Summit 2015 Recap
Last week was the annual PASS Summit in Seattle. The Summit is the predominant educational and networking event for SQL...
2015-11-03
617 reads
Where’s my Team Explorer 2015?
Team Explorer is a client software that can be used to integrate Visual Studio with an instance of Team Foundation...
2015-11-03
419 reads
Hekaton Part 10: Things Hash Indexes Can do
Hash Indexes on "In memory" tables are best suited for equality searches. Reason is obvious, as they are based on...
2015-11-02
496 reads
Shared SSDT Deployment Contributor Repository and Free Help
One of the best features of SSDT is deployment contributors. They are so exciting I am going to say it...
2015-11-02
427 reads
Shared SSDT Deployment Contributor Repository and Free Help
One of the best features of SSDT is deployment contributors. They are so exciting I am going to say it again with more gusto. One of the best features...
2015-11-02
13 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