Comparing Agent Jobs across Availability Group Replicas with PowerShell
On the plane home from PAS Summit I was sat next to someone who had also attended and when he...
2017-11-27 (first published: 2017-11-10)
1,570 reads
Blog Posts
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
33 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
158 reads
Installing Pester
One of the things that I believe strongly in is that we need better testing of software. Actually, what we...
2017-11-27
742 reads
Spaced-Out Strings
I came across this in a code review not long ago:
Three things pop into my head when I see this...
2017-11-27 (first published: 2017-11-13)
2,639 reads
Using PowerShell To Deploy Scripts From GitHub to Multiple SQL Servers
Now I’m all for making my life easier and one thing that makes life easier for me is having a...
2017-11-27
543 reads
Vigilant SQL DBA Vulnerability Management & 1st Look at Azure Vulnerability Assessments (Baltimore SSUG Session last week)
Just a quick note to share last Wednesday night's presentation on how to manage SQL Server vulnerabilities, plus a first...
2017-11-27
571 reads
Flexible connections and an old friend
TweetG’day,
Just lately I’ve found myself involved with an app that needed to run on a server and nearly always (although...
2017-11-26
453 reads
SQL SERVER ON LINUX INSTALLATION – PART4 – INSTALL SQL SERVER AGENT ON RHEL
In my previous tips, I explained about install RHEL Server on the virtual machine, install SQL Server 2017 on Red Hat Enterprise...
2017-11-25
612 reads
Tricks - Copy T SQL Result to Excel
Sometimes, some of the silliest of tricks save so much of time and effort. Very common scenario is to copy a query result to excel. Most take either of...
2017-11-25
19 reads
Blogs
T-SQLTuesday 204: Are blogs still relevant?
This month’s blogging party is hosted by Jeff Ianucci – his challenge is to...
Are Blogs Still Relevant? I Think They Still Are.
As for me, I'll keep writing whenever time permits. I don't expect every post...
Reading Blogs: T-SQL Tuesday #204
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Switching Schemas I
Comments posted to this topic are about the item Switching Schemas I
Enforcing Unique Customer Emails When Duplicates Already Exist
Comments posted to this topic are about the item Enforcing Unique Customer Emails When...
Question of the Day
Switching Schemas I
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers