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,090 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,129 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
965 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
950 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
797 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
278 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
481 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
542 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
430 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,320 reads
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Identities and Sequences III
Comments posted to this topic are about the item Identities and Sequences III
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers