SQL Server on Linux
When I started working with SQL Server many years ago, SQL Server on Linux was a regular April fool’s day...
2016-03-08
519 reads
Columnstore Indexes – part 79 (“Loading Data into Non-Updatable Nonclustered Columnstore”)
Continuation from the previous 78 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Update: In SQL Server 2016 the Nonclustered...
2016-03-07
574 reads
Curious case of SYS.MESSAGES
A strange error struck me last week, and this post is all about that. What you normally expect when you run SELECT * FROM sys.messages? The query will return a...
2016-03-07
11 reads
Curious case of SYS.MESSAGES
A strange error struck me last week, and this post is all about that.
What you normally expect when you run...
2016-03-15 (first published: 2016-03-07)
2,081 reads
Monday Morning SQL Break – March 7, 2016
It’s Monday and time for this week’s blog and twitter round-up. If you haven’t already, follow me on twitter (@StrateSQL). This...
2016-03-07
268 reads
SQL Server Backups Are A Business Decision
Blog post #3 in support of Tim Ford’s (b|t) #iwanttohelp, #entrylevel
Read more about Tim’s challenge here.
It’s very easy to think of...
2016-03-10 (first published: 2016-03-07)
1,810 reads
Restoring a Striped Backup–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-03-07
1,598 reads
Azure ML and R at This Week's BRSSUG/BRPBIUG
This Wednesday night, not only are we going to be showcasing the technology of the internet with an online presenter...
2016-03-07
458 reads
Recompile Monitoring using XEvents
How recompiles can hurt you, and how you can hunt them down using sql_statement_recompile.
2016-03-07
32 reads
Recompile Monitoring using XEvents
Recompiles can be a hidden bottleneck on your server, and it may not be too obvious. I should know, it...
2016-03-17 (first published: 2016-03-07)
1,653 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
How do I connect to a SQL Server database on my ISP?
I've got a web application for my side business. I've added a SQL Server...
Looking for New Blood
Comments posted to this topic are about the item Looking for New Blood
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers