What Do You Get if You Unpack an Ispac?
I’ve spent what feels like a lifetime working on automating SSIS deployments, more specifically SSIS packages that have been created...
2017-10-04
2,799 reads
Blog Posts
3 Tips You Need To Know When Using PowerShell with SQL Server
Watch this week’s interview with Drew on YouTube.
Have you ever had to perform repetitive tasks in SQL Server?
Maybe you’ve had...
2017-10-03
146 reads
3 Tips You Need To Know When Using PowerShell with SQL Server
Watch this week's video on YouTube
Have you ever had to perform repetitive tasks in SQL Server?
Maybe you've had to manually verify backups, script out all of a server's logins/groups/permissions,...
2017-10-03
5 reads
Always update your views
I last posted about changing a table without changing a view that represents the table and how this may affect...
2017-10-03
361 reads
Book Review: High Performance SQL Server
As SQL Server professionals, we sometimes encounter some issues that we haven’t seen before or have seen already but forgot...
2017-10-03
392 reads
Box-and-whisker plot and data patterns with R and T-SQL
R is particularly good with drawing graphs with data. Some graphs are familiar to most DBAs as it has been...
2017-10-03 (first published: 2017-09-25)
2,646 reads
Deploy SSAS Cubes With PowerShell
Hello!
Recently someone got in touch with me about one of my earliest posts on my old blog. I realised I...
2017-10-03
1,119 reads
Haunted SQL
I decided that for Halloween this year it would be fun to tell SQL ghost stories. When I tweeted about...
2017-10-03
339 reads
Introduction to SQL Server replication
This time I'll talk about some basis with SQL Server replication, whether you need it for High availability (HA), Disaster...
2017-10-03
723 reads
Power BI Custom Visuals Class (Module 70 – Custom Calendar By Akvelon)
In this module you will learn how to use the Custom Calendar by Akvelon. The Custom Calendar by Akvelon is...
2017-10-03 (first published: 2017-09-25)
2,108 reads
Blogs
Walking Through a Planned Failover: SQL Server Availability Groups on Kubernetes
When building the sql-on-k8s-operator, I wanted to make sure it could handle both planned...
Reading SQL Server File Headers with DBCC FILEHEADER
I’ve been doing a deep dive into SQL Server on-disk structures lately, and one...
T-SQL Tuesday #197 – An impactful session or two from a conference – RECAP
By DataOnWheels
Thanks to everyone who joined the blog party this month. I noticed three themes...
Forums
The Vector Data Type
Comments posted to this topic are about the item The Vector Data Type
What Power BI DirectQuery does to your SQL Server (and how to fix it)
Comments posted to this topic are about the item What Power BI DirectQuery does...
The New OS Wars
Comments posted to this topic are about the item The New OS Wars
Question of the Day
The Vector Data Type
What is the vector data type in SQL Server?
See possible answers