Fix For Using Azure Active Directory to Connect to SQL
Hello! The other day someone was kind enough to get in touch with me to thank me for some post I wrote back last year. For the sake of...
2019-03-12
7 reads
Richie Lee
PoshSSDTBuildDeploy 2.0.271.0 - Now With Better Exception Handling!
Hello!
Another quick bulletin about the changes I made to PoshSSDTBuildDeploy today -
2018-06-22
3 reads
PoshSSDTBuildDeploy 2.0.268.0 - Now With Issue Management!
Hello!
Concluding this weeks work on PoshSSDTBuildDeploy is adding one of the features I spoke about yesterday, which was joining the OperationSummary and Alerts objects to produce a new table...
2018-06-15
1 reads
PoshSSDTBuildDeploy 2.0.262.0 - Now With Warnings!
Hello!
Continuing on with my efforts to make the SSDT Deployment Report more useful, I’m pleased to say that I’ve added reporting on any alerts that appear in the Deployment...
2018-06-14
4 reads
More Changes to PoshSSDTBuildDeploy - DeployReport Information
Hello!
This is going to be a short one because I’ve been working hard all evening on this, and frankly I’m a little tired. But I’ve made a change to...
2018-06-12
5 reads
Birthday Musings and Deploy Using PoshSSDTBuildDeploy
Hello!
It is my birthday: another year older, another year not necessarily wiser. I’m planning on spending the evening watching the BBC and eating pizza. There are worse ways to...
2018-05-31
4 reads
Fix For Using Azure Active Directory and DacFX
Update:
Refer to this post instead
Hello!
One of the things I feel strongly about is that a build/release pipeline needs to be as complete as possible - that is all configuration...
2018-05-25
4 reads
PoshSSDTBuildDeploy Updated - Now With Pester Tests
Hello!
Some weeks ago I got the tests working on the CI build for PoshSSDTBuildDeploy. The tests were a bit of a mish mash, however they sort of did the...
2018-05-23
1 reads
PoshSSDTBuildDeploy Updated - Now With Install .NET!
Hello!
I’m currently working on a project that requires building and deploying SSDT-based projects. So it’s been a great opportunity of making use of PoshSSDTBuildDeploy and work through any issues....
2018-05-01
3 reads
Execute Multiple Files Using SQLCMD/SQLClient – Which Is Faster?
Hello!
I’ve been working on a PowerShell module that will migrate the schema of an Azure Data Warehouse from one database...
2018-02-26 (first published: 2018-02-15)
2,344 reads
Blogs
Reverse Engineering a Physical Model Diagram
By Steve Jones
I recently wrote about a logical diagram with Redgate Data Modeler. That was interesting,...
Prepping for Certification, Part 3 of ?
By Brian Kelley
After I have understood the details for a certification test (part 1), including format...
SQL Training Black Friday Deals
By Brian Kelley
If you're looking for particular "Black Friday" deals, here is what I've seen advertised...
Forums
Best analysis approach to reduce data type length in multiple tables
Hello SSC, I hope everyone is having a happy and safe holiday season! I...
Do you separate data/log files and TempDB files on different disks using AWS EC2
Hello, I am receiving multiple direction on deploying SQL Servers in AWS EC2. ...
Service account being in local admin in AWS EC2 environment?
Hello, I am working with a company on their database administration. I am trying...
Question of the Day
A New Operator
In SQL Server 2025, what does this code return?
SELECT '1' || '0'See possible answers