Making Start-Demo work with multi-line commands without a backtick
I love to speak about PowerShell. I really enjoy giving presentations and when I saw Start-Demo being used at the...
2016-08-29
520 reads
I love to speak about PowerShell. I really enjoy giving presentations and when I saw Start-Demo being used at the...
2016-08-29
520 reads
What is DBA Tools?
A collection of modules for SQL Server DBAs. It initially started out as ‘sqlmigration’, but has now...
2016-07-20
985 reads
So with the July Release of SSMS everything changed for using PowerShell with SQL. You can read the details here...
2016-07-14 (first published: 2016-07-03)
3,048 reads
The post on the SQLServer blog at TechNet by the SQL Server Tools Team today made me jump out of...
2016-06-30
989 reads
When I was at PowerShell Conference EU in Hannover last month (The videos are available now – click here and the...
2016-05-24
604 reads
It started with a tweet from Dusty
The second session I presented at the fantastic PowerShell Conference Europe was about using the...
2016-05-16
777 reads
So SQLBits has finished for another year. About 1500 people registered for the largest SQL Conference in Europe held over...
2016-05-10
646 reads
When you look after more than a few SQL Servers you will need to perform the same actions against a...
2016-04-08 (first published: 2016-03-28)
1,640 reads
If you use SQL Backup to URL to backup your databases to Azure blob storage remember that for the container name...
2016-03-11 (first published: 2016-03-03)
1,211 reads
This error caught me out. I am putting this post here firstly to remind me if I do it again...
2016-02-08 (first published: 2016-01-31)
1,735 reads
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
I have a SQL Server 2019 Enterprise Edition on CU 25. It has in-memory...
Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers