Technology Flows Downstream
The technologies that we see in other data platform products sometimes flow to SQL Server.
2019-06-20
247 reads
Editorials
An Alert Philosophy
Many of you reading this will be responsible in some way for managing a system. This might be a test/development system or a production one, but often you want to know how well the system is working. Or maybe you want to know if the system is working at all. Even developers care if their […]
2019-06-19
239 reads
Segments for Protection
Computer network security is important, and it's something we ought to be more concerned with as data professionals.
2019-06-18
275 reads
SSMS or SSDT
The question this week deals with tools. Steve Jones is looking to see which tools are preferred by most database developers.
2019-06-17 (first published: 2015-03-27)
1,232 reads
Microsoft and Oracle Cloud Partnership
Many of us checked to make sure it wasn’t April Fools Day a couple of years ago when Microsoft announced that SQL Server 2017 would run on Linux. This means that some shops who want to run SQL Server, but not Windows Server, now can. But it also means that SQL Server professionals need to […]
2019-06-15
206 reads
2019-06-14 (first published: 2015-05-19)
586 reads
Upgrading Your OS
Windows 7 support is ending, but Microsoft doesn't have a good plan for home users. Steve notes that the OS upgrade treadmill ought to come to an end soon.
2019-06-13
184 reads
Are We Suckers?
This week Steve Jones wonders if we work too much. Do we give more to our employers than they give to us?
2019-06-11 (first published: 2015-12-18)
1,032 reads
Setting Session Skill Levels
Kathi Kellenberger discusses the challenge of deciding how to describe the content in the sessions she presents.
2019-06-10
341 reads
Building or Buying Analytics
One of the decisions that I've been involved with at the beginning of every software project is whether to buy software to solve the problem or build our own. This might be a quick "is there software anyone knows about to do this?" query, or an in-depth review of the marketplace or something in between. […]
2019-06-08
220 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
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...
Tools for MySQL memory estimations and optimization?
Hi all! I’ve been using MySQLCalculator.com for memory calculations, but I’m looking for alternatives...
Question of the Day
The Hash Join II
Which of these inputs is the smaller input to a hash join?
See possible answers