Modeling and Design Are More Important in DevOps
Steve notes that modeling and good database design can't be ignored in DevOps work.
2018-10-15
44 reads
Editorials
The Importance of Consistent Server Setup
In larger shops with multiple database servers, it is very important to have consistency.
2018-10-12
150 reads
2018-10-11
446 reads
Normal Data
More and more people are starting to perform data analysis, including DBAs, but they should be aware of what normal means for data.
2018-10-10 (first published: 2015-01-28)
192 reads
Single Source of Truth
Andy Warren talks about the single source of truth for information. It could be the database, but that's not always the best choice.
2018-10-09
232 reads
Remember the Simple Things
Steve has a troubleshooting experience that reminds him of a lesson he should have learned.
2018-10-08
66 reads
What Should You Look for in a SQL Monitoring Tool?
Performance is a common reason to monitor SQL Server. The work day of a database administrator is often interrupted with unexpected calls about slowness in applications or reports. But, how does the performance today compare to the performance last week or last month? Can the root cause of the issue be traced to the database […]
2018-10-08
35 reads
The Single Pane of Glass
The idea of a single place to get the status of your environment is an interesting one.
2018-10-05
76 reads
2018-10-04
50 reads
2018-10-03
36 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
A Strange Query
Comments posted to this topic are about the item A Strange Query
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...
Question of the Day
A Strange Query
What does this return?
SELECT x=1 WHERE (SELECT 1) IN ( 1, 2, 3)See possible answers