SSIS Web Service Task: misleading role of WSDL file
[2017-Mar-31] You can call one of your web service methods in SSIS package using a .NET script task or you can just...
2017-03-31
3,521 reads
Blog Posts
Thoughts on PASS Summit Speaker Selection Changes
Recently the PASS Blog released some changes to the speaker selection process that have generated some commentary and thoughts from...
2017-03-31
813 reads
Applying SQL Service Pack on Encrypted Drives
I have a server that uses a third party disk encryption product. It’s configured so that the SQL service account...
2017-03-30
708 reads
Basics of Probability
In this post am going to introduce into some of the basic principles of probability – and use it in other posts...
2017-03-30 (first published: 2017-03-20)
4,514 reads
Check Those Settings
Recently, I was tasked with “enhancing” a third party application. This third party application (TPA) outputs a bunch of files...
2017-03-30 (first published: 2017-03-16)
2,285 reads
Looking Back at the SQL Clone Launch(es)
Yesterday was the SQL Clone launch livestream from the Redgate office in Cambridge, UK. I flew over on Monday, along...
2017-03-30
1,044 reads
Your physical memory configuration can slow down your servers
Watch your memory configuration! You can’t just throw RAM in a physical server and expect it to work right. Depending on...
2017-03-30
716 reads
A First Look At Normalization
Phew! There’s a lot to take in with data types, collation, precision, scale, length, and Unicode, and we’re just getting...
2017-03-29
320 reads
Getting SQL Server File Sizes and Space Used with dbatools
I read a great blog post about answering the question how big is the database using T-SQL on SQL Buffet...
2017-03-29
986 reads
Increasing and decreasing the performance level of your Azure SQL Database
One of the big benefits of Azure, and in fact any of the cloud offerings I’ve seen, is the ability...
2017-03-29
730 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