Combating SQL Injection
Target. Home Depot. NASA. U.S. Army. Anthem. Wall Street Journal. MarketWired. Ashley Madison. What do they all have in common?...
2017-06-21
810 reads
Blog Posts
dbatools at #SQLSatDublin
This weekend SQL Saturday Dublin occurred. For those that don’t know SQL Saturdays are free conferences with local and international speakers...
2017-06-21
920 reads
Dynamically generate the command line DMA statement for each database
If you are upgrading your instance to 2016 (or 2017 soon) then you probably are going to want to run...
2017-06-21
661 reads
How to Automate Processing of Azure Analysis Services Models
I’ve been working on a proof of concept for a customer that involved using Azure Analysis Services as a cache...
2017-06-21
2,601 reads
How to Automate Processing of Azure Analysis Services Models
I’ve been working on a proof of concept for a customer that involved using Azure Analysis Services as a cache...
2017-06-21
545 reads
Microsoft Data Insights Summit Day 1 Recap: Power BI Visio & PowerApps Integration, Custom Drill Through Actions, Book Marks, What If Analysis, & Data Insights
If you were at the Microsoft Data Insights Summit or were watching the live stream of the keynote, then you...
2017-06-21 (first published: 2017-06-13)
2,943 reads
Understanding Relative Risk – with T-SQL
In this post we will explore a common statistical term – Relative Risk, otherwise called Risk Factor. Relative Risk is a...
2017-06-21 (first published: 2017-06-19)
1,975 reads
Why You Need A Test Environment
In 2017, there’s no excuse not to have at least a testing environment, and preferably a development environment as well,...
2017-06-21
142 reads
Working on my Microsoft Professional Program for Data Science
Microsoft announced a new program last year to help you understand the skills that a Data Scientist needs in their...
2017-06-21
482 reads
5 Business Problems You Can Solve With Temporal Tables
Watch this week's video on YouTube
It's 4:30 pm on Friday and Mr. Manager comes along to tell you that he needs you to run some important ad-hoc analysis for...
2017-06-20
35 reads
Blogs
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Forums
Alamat BCA KCP Thamrin Nine Telp:0821°7555°651
Telp/Wa 628217555651 Thamrin Nine Podium Area - UG Unit A, Jl. MH Thamrin No.10,...
Alamat BCA KCP Samanhudi Telp:08218200203
Telp/Wa 628218200203 Jl. Samanhudi No.57 B, RT.5/RW.3, Ps. Baru, Kecamatan Sawah Besar, Kota Jakarta...
Alamat BCA KCP AM Sangaji Telp:08218200233
Telp/Wa 628218200233 Jl. A.M Sangaji No.020 A, RT.3/RW.04, Petojo Utara, Kecamatan Gambir, Kota Jakarta...
Question of the Day
Checking the Error Log III
If I want to run sp_readerrorlog on SQL Server 2025, what permissions do I need?
See possible answers