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's SQL Stuff
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
3 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,342 reads
Blogs
Cosmos DB vs Traditional SQL: When to Choose What
By Chris Yates
From where I stand, the decision between Cosmos DB and a traditional SQL database...
Monday Monitor Tips: Searching Procedures
By Steve Jones
A customer was asking about how to track all the stored procedures that execute...
Forums
SQL Connectivity
Hi everyone, I'm currently working on building an MCP integration for SQL Server. Most...
The Next Great Thing
Comments posted to this topic are about the item The Next Great Thing
Building a Database Dashboard with SSRS
Comments posted to this topic are about the item Building a Database Dashboard with...
Question of the Day
Enabling Change Tracking
If I want to set up Change Tracking in a database, what should I do first in SQL Server 2022?
See possible answers