GDPR in the USA
GDPR enforcement began in May of 2018, but if you are doing business in the US, you may not think it applies to you. Grant Fritchey explains why you might be wrong about that and why you need to act now.
2019-04-16
GDPR enforcement began in May of 2018, but if you are doing business in the US, you may not think it applies to you. Grant Fritchey explains why you might be wrong about that and why you need to act now.
2019-04-16
I read a lot of history (as you no doubt notice from my other editorials). I’m currently reading an excellent book on the air war in World War One, Marked for Death: The First War in the Air. One of the fascinating aspects of the war is just how fast the technology shifted. At the […]
2018-01-22
20 reads
2017-07-06
3,083 reads
Every Database Administrator, developer, report writer, and anyone else who writes T-SQL to access SQL Server data, must understand how to read and interpret execution plans. This book leads you right from the basics of capturing plans, through how to interrupt them in their various forms, graphical or XML, and then how to use the information you find there to diagnose the most common causes of poor query performance, and so optimize your SQL queries, and improve your indexing strategy.
2017-02-02
18,246 reads
Grant Fritchey reviews Midnight DBA's Minion Reindex, a highly customizable set of scripts that take on the task of rebuilding and reorganizing your indexes.
2015-01-27
2,267 reads
SQL Server 2014 is being released and a change in the defaults will ensure that more instances will run smoother.
2014-04-01
2,616 reads
How to use Profiler to generate TSQL scripts that can be modified and automated to run as a server-side trace
2013-12-31 (first published: 2010-12-02)
12,554 reads
This book shows how to use of mixture of home-grown scripts, native SQL Server tools,
and tools from the Red Gate SQL Toolbelt, to successfully develop database applications in a team environment,
and make database development as similar as possible to "normal" development.
2013-08-26
4,736 reads
Every day, out in the SQL Server forums, the same questions come up again and again: why is this query running slow? Why isn't my index getting used? In order to arrive at the answer you have to ask the same return question in each case: have you looked at the execution plan? Grant Fritchey provides the only dedicated and detailed book on this essential topic.
2013-03-15
48,834 reads
You can extend SQL Monitor to track whatever you need to watch on your own system with custom metrics. Grant Fritchey shows us how.
2013-01-15
2,464 reads
By Steve Jones
Here are the slide decks for my sessions at SQL Saturday Jacksonville 2022 Continuous...
By James Serra
When using Power BI and pulling data from Azure Synapse, you will use the...
By MAMIR
Azure Privatelink provides private connectivity from an Azure Virtual Network to Azure PaaS such...
\hello Guys, Mayyou help wuth the corect index filetred creation using modulo? ...
Ahoi, i am usually working with SSIS and SSAS, but since there is no...
Hi Experts Not able to do DATEDIFF between two dates, but it works when...