A Mindset Shift
Microsoft has grown and changed their culture in the last few years, which greatly impresses Steve.
2019-11-01
302 reads
Microsoft
Evergreen SQL Server
Microsoft talks about evergreen SQL, where you never need to patch your database.
2019-07-24
1,231 reads
DevOps and OSS Can Scale
Microsoft has embraced open source software, and has opened much of their code. They have also proven that DevOps development can scale in this environment.
2019-07-17
182 reads
More Linux than Windows
Microsoft announced that Linux runs on more machines in Azure than Windows. Steve isn't surprised and thinks that Linux use will continue to grow.
2019-07-06
190 reads
2019-06-26
168 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
183 reads
Microsoft’s Windows XP Finally Dead: Last Embedded Version Reaches EOL
Microsoft this week ended support for the very last Windows XP-based operating system, essentially marking the end of the platform and an era. Being one of the longest living...
2019-04-11
Introduction to Microsoft R Services in SQL Server 2016
General introduction to R Services in SQL Server 2016 and how R server works with external stored procedure.
2019-01-25 (first published: 2016-09-15)
8,575 reads
Survey: What are your plans to upgrade SQL Server?
The Microsoft SQL Server product group are evaluating how to better assist with your SQL Server upgrades. With the upcoming SQL Server 2005 extended support deadline fast approaching, they want to understand how to help you migrate to a modern, supported version of SQL Server, and how to provide support and upgrades in future.
2015-07-17
5,452 reads
Helping MS Help Us
The Microsoft Connect system allows many of us to submit feedback, but is Microsoft doing anything with it? Join us and place your vote on some items and try to influence Microsoft.
2013-05-29
48 reads
Blogs
Convert SQL Audit Files to a CSV Using Read-SqlXEvent
By Patrick
SQL Server Audit is an efficient way to track and log events that occur...
Control Flow Restartability in Azure Data Factory
I presented at SQL Saturday Pittshburgh this past weekend about populating your data warehouse...
Monday Monitor Tips: Knowing Your RPO
By Steve Jones
A customer was asking recently about the RPO for their estate, and I showed...
Forums
Wrong frames in blocked process report
Hi all, I'm on a sql server 2019 standard edition (15.0.4375.4) where I've a...
SRSS Failed Setup " The System cannot find the file specified (0x80070002)
Dear All, I am facing issue when update my license SRSS 2022 from...
Git Repo(s) for SQL Server Database, SSIS, SSAS, SSRS, PowerBI
Hey all, Just wondering how do you guys / girls set up git repo(s)...
Question of the Day
STRING_AGG's behavior
Executing the following script (Sql Server 2022), you get the table t0 with 10 rows:
CREATE TABLE t0
( id INT PRIMARY KEY
, field1 VARCHAR(1000)
, field2 VARCHAR(MAX));
INSERT INTO t0
SELECT
gs.value
, REPLICATE ('X', 1000)
, REPLICATE ('Y', 1000)
FROM generate_series(1, 10, 1) gs;
GOWhat happens if you execute the following statements?
select STRING_AGG(field1, ';') within group (order by id) from t0;
select STRING_AGG(field2, ';') within group (order by id) from t0;