Learning R: Hitting the Books
I’ve been using a series of web sites while I was starting the process of learning R. I’ve highlighted several...
2016-01-13
591 reads
Verifying Instant File Initialization
Verifying Instant File Initialization
Ran into a few issues verifying instant file initialization. I was trying to ensure that file initialization...
2016-01-13
255 reads
Basic Windows Administration through Powershell
Hi Guys,
In the previous blog I took you through PowerShell basics We know that PowerShell to works with different modules...
2016-01-21 (first published: 2016-01-13)
2,584 reads
Verifying Instant File Initialization
Ran into a few issues verifying instant file initialization. I was trying to ensure that file initialization was enabled, but...
2016-01-13
324 reads
Parallelism setting in SQL Server – reduce CXPACKET waits?
This is one of the hot topic within the DBA community, what should be the best setting for parallelism in your environment? The answer is – it depends! J
Let’s...
2016-01-13
79 reads
Managing Change Data Capture T-SQL Tuesday #74
T-SQL Tuesday is here again. This month the host is Robert Davis (b | t)
The topic for T-SQL Tuesday #74 is...
2016-01-12
446 reads
T-SQL Tuesday #74–The Changes
It’s T-SQL Tuesday time, the monthly blog party on the second Tuesday of the month. This is the first T-SQL...
2016-01-12
586 reads
T-SQL Tuesday #74: Ch-ch-changes
Welcome to my contribution for T-SQL Tuesday 74 being hosted by me. So special thanks to me for hosting it....
2016-01-12
740 reads
New Year, New Look, New Focus
Happy New Year, and welcome back! One of the projects I undertook over the holidays was to give the site...
2016-01-12
287 reads
3 Reasons to Attend SQL Saturday Austin on Jan 30th
The Austin SQL Server User Group will host its third SQL Saturday on Saturday,
SQL Saturday Austin on January 30th, 2016
January...
2016-01-12
478 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