(Grant Fritchey) This weekend I was in Stockholm in Sweden, talking Query Store and plan forcing with Steinar Anderson, when he mentioned the problems he had while forcing plans that had table variables in them.
Tag: sql server
SQL Injection Protection
(Thomas LaRock) SQL injection is a common form of data theft. I am hopeful we can make SQL injection protection more common.
How to Reseed Your Identity Column Value in SQL Server
(Greg Larsen) Have you deleted a bunch of rows from a table that has an identity column value?
Read, Enrich and Transform Data with AWS Glue Service
(Maria Zakourdaev) In the first part of this tip series we looked at how to map and view JSON files with the Glue Data Catalog. In this second part, we will look at how to read, enrich and transform the data using an AWS Glue job.
Possibly the worst analogy in the world – columnstore and ordering
(Tibor Karaszi) Yeah, the subject is sort of a tribute to the Tenacious D tribute. With a hint of Carlsberg in there.
SQL Server Monitoring Week – Spotlight Cloud
(Pinal Dave) Today I am starting a week-long series where I will be discussing various SQL Server Monitoring Tools. My primary aim is to help people with my consulting workshop Comprehensive Database Performance Health Check. While I help customers with their various SQL Server performance issues, I
Shrinking a large database with limited outage windows
(Kenneth Fisher) Yes, I realize you shouldn’t shrink your database (data files or log files), but I recently had a case where it was completely appropriate to do a shrink. We had a table that was almost a terabyte on its own.
Using IGNORE NULLS With SQL Window Functions to Fill Gaps
(lukaseder) I found a very interesting SQL question on Twitter recently:
Data Lake vs. Data Warehouse
(Sadequl Hussain) We are already running a large data warehouse for our business, but now the management wants us to build a data lake. What’s the difference? Where will we use it? Who will use it?
Minimal Logging with INSERT…SELECT into Heap Tables
(Paul White) Achieving minimal logging with INSERT…SELECT can be a complicated business.
