The Hour of Code 2015
This year I was interested to see that they did the Hour of Code in the elementary school my daughter...
2015-12-10
634 reads
SQL F.A.D. – Trace flag 834 and columnstore indexes - Syndication – WaterOx Consulting
Trace flags can be good Are special codes we, the DBA, can use to change the way the SQL Server...
2015-12-10
573 reads
Promote Community
When I present at any given event, I generally assume that the people attending have heard of the event that...
2015-12-10
492 reads
Using unique constraints
I ran into an interesting problem the other day. Given the title of the post, obviously a unique constraint was...
2015-12-10
1,632 reads
Hadoop Fundamentals
Have you heard about Hadoop, but never really understood what it’s all about?
Do you need to learn about Hadoop, either...
2015-12-14 (first published: 2015-12-10)
3,416 reads
SQL Server – Trace flag changes in Dynamic data masking in SQL Server 2016 CTP 3.0
Hi friends, In new CTP version SQL server 2016 which is 3.0, I was trying to explore the new masking...
2015-12-10
486 reads
Open Live Writer
I’m writing this post from the Open Live Writer project software. I’ve used Live Writer for years, but it’s shown...
2015-12-09
608 reads
Documenting Your Database with Diagrams
Documenting Your Database with Diagrams
Don’t get too excited. I know you love documentation, and just can’t wait to spend some...
2015-12-09
1,149 reads
Running Powershell with Task Scheduler
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as#SQLNewBloggers.
One...
2015-12-09
2,532 reads
PASS Board Update: First Year
This represents my 12th month on the board so I thought I would recap my time there so you know...
2015-12-09
484 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