I've been chosen to speak at SQL Saturday Guatemala
I'm thrilled to announce that one of my proposals has been chosen to be presented in Guatemala's SQL Saturday that will be held on February 3rd at the Francisco...
2018-01-20
2 reads
SQLDbaInternals
I've been chosen to speak at SQL Saturday Guatemala
I'm thrilled to announce that one of my proposals has been chosen to be presented in Guatemala's SQL Saturday that...
2018-01-19
124 reads
Configure Always on AG with SQL 2017
One of the new features that we have with SQL 2017 is that you no longer need a Windows cluster to enable the AlwaysOn feature with SQL server (remember...
2017-12-04
36 reads
Configure Always on AG with SQL 2017
One of the new features that we have with SQL 2017 is that you no longer need a Windows cluster...
2017-12-04
24,786 reads
Create users in Azure AD
In this post I'll show you how to create new users in your Azure Active Directory so you can use them as service accounts or to grant other users...
2017-11-27
9 reads
Create users in Azure AD
In this post I'll show you how to create new users in your Azure Active Directory so you can use...
2017-11-27
128 reads
Configure an Azure AD Domain Services
Problem: I was working on getting a demo on how to setup Always On with SQL Server 2017 without the need of creating a windows cluster, I had my...
2017-11-20
67 reads
Configure an Azure AD Domain Services
Problem: I was working on getting a demo on how to setup Always On with SQL Server 2017 without the...
2017-11-20
157 reads
Contained Databases setup
Last weekI wrote about what is a contained database, the benefits and challenges, today as promised I'll show you how to setup one, how to configure a user and...
2017-11-08
3 reads
Contained Databases setup
Last weekI wrote about what is a contained database, the benefits and challenges, today as promised I'll show you how...
2017-11-08
229 reads
Blogs
Friday Flyway Tips: State-based deployment with Flyway Teams
By Steve Jones
I was asked about state-based deployments in Flyway Teams, so I decided to show...
Advice I Like: The Main Thing
By Steve Jones
The main thing is to keep the main thing the main thing. – from...
Sic Transit Gloria Community
When Covid took out the PASS organization, I had someone say to me, “Well,...
Forums
Dynamic T-SQL Script Parameterization Using Python
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
Installing SQL FCI Instance certificates
SQL FCI Instance certificates I have a client who has a requirement for certificates...
Log Shipping Not Able to Restore Log Files in Secondary
I'm attempting to set up log shipping from SQL Server 2005 Standard to SQL...
Question of the Day
Counting Bits IV
What do these two selects return?
SELECT BIT_COUNT (CAST (-1 as smallint))
, BIT_COUNT (CAST (-1 as bigint))
See possible answers