Debugging SQL Server
This week we have a more technical poll as Steve Jones wonders how you best debug your T-SQL code.
2019-05-27 (first published: 2015-01-16)
459 reads
Editorials
2019-05-25
353 reads
2019-05-24
344 reads
Burning Out
Burning out in an IT job is easier to do than it should be. Steve has a little advice today.
2019-05-23
441 reads
2019-05-22 (first published: 2015-03-17)
326 reads
No State Based Deployments
Today Steve Jones talks about deploying your database changes, and how you can't ever really depend on a state based approach.
2019-05-21 (first published: 2015-03-02)
287 reads
What Limits Do You Want in 2019?
With SQL Server 2019 getting closer to release, Steve asks about the hardware limitations that we should have in Standard Edition.
2019-05-20
1,483 reads
Why Tools Can Help You Do Your Job
Back in my days as a SQL server DBA, I didn't have many third-party tools at my disposal. I remember having a monitoring tool with licenses for only three or four SQL server instances. Whenever there was a problem with one instance that wasn’t currently being monitored, I would have to stop monitoring another instance […]
2019-05-18
211 reads
The Other Jobs
This week Steve is asking what jobs you might choose if you had the chance, as well as those you enjoyed, or perhaps dreaded.
2019-05-17
243 reads
2019-05-16
567 reads
Blogs
Finding fields used in a Power BI report in PBIR format with Semantic Link Labs
Have you ever wondered where a certain field is used in a report? Or...
Adding Test data to msdb.sysjobhistory
By Steve Jones
One of our internal people was looking to test some process in (I assume)...
Microsoft Ignite Announcements Nov 2024
By James Serra
Announced at Microsoft Ignite last week were some new product features related to the...
Forums
Primary and Secondary Filegroup
Hello, I am having database primary and secondary filegroup. Few tables/indexes are partitioned on...
Import data from json file with special characters
I am using the following script to import data from a json file. This...
% processor Time in Activity monitor is greyed out
When I connect to my SQL Server using SQL Server Management Studio (SSMS) from...
Question of the Day
The Hash Join II
Which of these inputs is the smaller input to a hash join?
See possible answers