Webinar – Easy SQL Server Benchmarking
On Thursday, May 1st, I will be presenting a new webcast with Tegile Systems entitled “Easy SQL Server Benchmarking”.
Abstract: Do you have a new piece of...
2014-04-30 (first published: 2014-04-21)
1,418 reads
Notes From The April 2014 oPASS Meeting
Same room but different seating arrangement. Instead of separate table pushed some together, used the space better and more a...
2014-04-21
523 reads
Collation: Temporary objects and variables: Demonstration
I had a recent run in with collation problems and it got me started reading about them. As I read...
2014-04-21
473 reads
Collation: Temporary objects and variables: Demonstration
I had a recent run in with collation problems and it got me started reading about them. As I read...
2014-04-30 (first published: 2014-04-21)
2,078 reads
FileTables–Inserting Directories from T-SQL
Creating a directory in a Filetable share is easy. It looks like this:
It’s hard to see, but this was a...
2014-04-29 (first published: 2014-04-21)
2,736 reads
Central Management Studio CMS
By David Postlethwaite
At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some...
2014-04-28 (first published: 2014-04-21)
1,981 reads
New release 2.4.5222
Today we released new version of SQL Code Guard - 2.4.5222There are many fixes and improvements, some new rules were added.Full...
2014-04-20
347 reads
Creating a Dynamic, Parameterized Measure in DAX
As I continue to explore the many facets of DAX functions, I’m finding more creative ways to add business value...
2014-04-20
891 reads
Modern DataWarehouse: The Weakest Link
It has been quite some time, that the term Modern Data Warehouse has appeared on the horizon of so many...
2014-04-20
210 reads
Hangout #18 with Boris Hristov
Yesterday evening I had the honour and pleasure of recording one of his famous SQL Hangout with my friend Boris Hristov (b|t).
We...
2014-04-18
259 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