SQL Server 2008 R2 SP3 Install Errors
Whenever it is time to install a service pack every DBA silently hopes that nothing will go wrong. I would...
2015-05-28
2,097 reads
Blog Posts
SQL Server 2016 Live Query Statistics
So now that SQL Server 2016 CTP2 is released to the public we can all finally play with all the...
2015-05-28
3,138 reads
Sysmail_add_account_sp – SQL Server Database Mail Stored Procedure – Part 5
Hi friends, today we will continue with database mail stored procedure and will learn how to create database mail account...
2015-05-28
970 reads
Columnstore Indexes – part 54 (“Thoughts on upcoming improvements in SQL Server 2016”)
Continuation from the previous 53 parts, the whole series can be found at http://www.nikoport.com/columnstore/
This is a not very deep technical...
2015-05-27
954 reads
How an MPP appliance solution can improve your future
Massive parallel processing (MPP) is the future for data warehousing.
So what is MPP? SQL Server is a Symmetric Multiprocessing (SMP) solution, which...
2015-05-27
802 reads
Maintaining Parallel Power Pivot and SSAS Tabular Models–Tales from the Trenches
This post is really a collection of field notes and some lessons learned from recent project experience. I’ve done plenty...
2015-05-27
487 reads
Maintaining Parallel Power Pivot and SSAS Tabular Models–Tales from the Trenches
This post is really a collection of field notes and some lessons learned from recent project experience. I’ve done plenty...
2015-05-27
279 reads
PASS Board Update: May 2015
I’ve had a busy month on the Board.
You may have seen some tweets going by about our compliance with international...
2015-05-27
544 reads
Speaking at ITPROceed 2015
This year I have the opportunity again to speak at ITPROceed, the biggest (Microsoft-related) conference in Belgium for the IT...
2015-05-27
433 reads
SQL Agent Job Wrapper Part 2 – Adding Error Generation to the Cmdlet
Last week I posted Creating a SQL Agent Job Wrapper with PowerShell and SMO. In that post I created a...
2015-05-27 (first published: 2015-05-20)
5,338 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers