SQL Cruise 2017 – Western Carribean – my experience
As some readers may know, I am a regular attendee on SQL Cruise s for 8 years now. SQLCruise is...
2017-02-19
627 reads
I’m a VMware vExpert
To add to an already amazing year, recently I was named a VMware vExpert for 2017. I’m honored, humbled, and...
2017-02-19
161 reads
vCenter Server fails to start, Purge and Shrink Vcenter SQL Database
One of my client vCenter Server fails to start as below shown error in event logs.Could not allocate space for...
2017-02-17
652 reads
Gartner Magic Quadrant for BI 2017 Top 3 Rankings
This is a different spin on the top three vendor rankings visualized in Power BI. According to the placement of...
2017-02-17
813 reads
The Costs of Hiring Cheaper Consultants
From time to time, I see posts in forums from people complaining about how much some consultants charge. A really...
2017-02-17
610 reads
Friday Reading 2017-02-17
Is it me or is February dragging? Anyway, mixed in with this crazy week I’ve been reading: –
SQL Server vs...
2017-02-17
345 reads
CLR Stored Procedure Cannot Be Marked as System Object?
It is an open secret that in SQL Server, we can “create a system object” by using an undocumented stored...
2017-02-17
817 reads
Updates to the Power BI course
Recently I published an open-source course/workshop to learn Power BI Desktop. Fellow MVP Dan English (blog | twitter) gave me the...
2017-02-16
488 reads
Getting Started with PowerBI: Building Graphs (Part 3)
This is part 3 of the Getting Started with Power BI series. Power BI is a powerful reporting and dashboarding...
2017-02-16
177 reads
Deadlock on ALTER DATABASE
I had an interesting problem recently. A database was stuck in single user mode. How exactly was it stuck you...
2017-02-16
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