Pulling Together
A number of companies worked together to ensure that they could meet the challenge of the NHS. Sharing data was critical to this effort.
2020-10-08
122 reads
Editorials
AI Data
Data is important for AI projects, but the ethics and privacy implications are complex. A new project from Microsoft aims to help users control their data and make it available for use.
2020-10-07
121 reads
DevOps and Exhibits
DevOps continues to improve the way we build software and Steve has a good example in today's editorial.
2020-10-06
70 reads
Detecting Logins
A recent issue with malware and SQL Servers has Steve wondering if you would detect a new, and unapproved, login added to an instance.
2020-10-05
216 reads
Azure Resource Mover
Microsoft recently held the 2020 Ignite conference. Just like in previous years, there were many announcements introducing new services and expanded capabilities of existing ones, especially in Azure. Ahead of Ignite, I was asked to take a test drive of one of the new features, Azure Resource Mover (in preview). It’s easy to move a […]
2020-10-03
190 reads
2020-10-02
124 reads
DR as a Service
It's not the first task when I start a new job, but often as a DBA or developer, I usually ask about Disaster Recovery (DR) plans sometime within the first six months. If I'm a DBA, of course I need a plan. If I'm a developer, however, I still need to understand how this might […]
2020-10-01
109 reads
2020-09-30
149 reads
Keeping Your Staff
Retaining staff is always a challenge for many organizations. Today Steve talks about the difficulties of doing so and in choosing who to retain.
2020-09-29
147 reads
Do You Know What the Settings Should Be?
Estate management keeps getting more complex, especially with the move to the cloud, or to multiple clouds. Today Steve talks about the need to ensure you know what the settings are in your environments.
2020-09-28
90 reads
Blogs
A Broken Copilot Query
By Steve Jones
I was testing the new SSMS (v22 Preview 3) with Copilot and ran into...
SQL Server Alerts
By Kevin3NF
Don’t Let Trouble Sneak Up on You Most SQL Servers run quietly. Until...
Prompt AI helping with Auditing
By Steve Jones
I had a conversation with a customer asking this question: how can I tell...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Collation errors...what is best way to deal with it?
Hi I have a SP that occasionally get this error: Cannot resolve the collation...
Was the index created or not?
Hi everyone I am getting an error when I create the index but I...
Question of the Day
Estimated Rows
I have two calls to the GENERATE_SERIES TVF in this code:
SELECT TOP 10 gs.value FROM GENERATE_SERIES(1, 10) AS gs ORDER BY NEWID () OPTION (RECOMPILE); go DECLARE @a int = 10; SELECT TOP (@a) gs.value FROM GENERATE_SERIES(1, @a) AS gs ORDER BY NEWID () OPTION (RECOMPILE);In the actual query plans, what is the estimated number of rows for each batch in SQL Server 2022? See possible answers