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
803 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
911 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
660 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,588 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
538 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,930 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,973 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
135 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
478 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
28 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers