How are you recharging this year?
Steve Jones asks about your plans to get away from work and refresh yourself.
2018-06-29
51 reads
Editorial
String or binary data would be truncated
This is an error that has plagued SQL Server for a long time. It should be fixed.
2018-06-28
323 reads
2018-06-25
59 reads
2018-06-21
143 reads
Providing Feedback to Speakers
One of the greatest things that has arisen in the past 10 years or so is a veritable stream of great conferences for people to learn how to write better software, many of them low cost or even free. In the Data Platform community, we have had nearly 800 free SQL Saturday events around the […]
2018-06-18
45 reads
More Query Tuning?
What types of sessions are important in a conference schedule? Steve Jones talks a bit about the lack of tuning sessions.
2018-06-15
85 reads
Building Test Data
Steve talks about the importance of test data and how to get it in development environments.
2018-06-14
57 reads
2018-06-13
84 reads
Machine Learning in the Database
Steve talks about Machine Learning Services in SQL Server and whether using this is a good idea.
2018-06-12
170 reads
Be Prepared with Baselines
Analyzing performance often requires you to understand what is normal and what is not. Steve talks about the importance of baselines.
2018-06-11
64 reads
Blogs
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...
From Data Custodian to Innovation Catalyst: The Evolving Role of the CDO
By Chris Yates
There was a time when the Chief Data Officer lived in the shadows of...
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