Analysis Services Server Activity Monitor 2014 0.0.0.1 Alpha Released
This morning I am happy to announce the release of an alpha version of the SSAS Activity Viewer for SQL Server 2014 CTP2. The name has had a slight...
2013-11-11
7 reads
Blog Posts
Automated Permissions Auditing With Powershell and T-SQL: Part 1
A big part of my job is controlling security to multiple production databases, and reporting on that security for quarterly...
2013-11-11
1,036 reads
Dealing with Power Pivot to Tabular Upgrade Errors
Upgrading from Power Pivot workbooks to SSAS Tabular models is usually a pretty seamless process. This is part of the...
2013-11-11 (first published: 2013-11-04)
1,830 reads
Floating Fill Factors, Automation at work!
A while back I saw a wonderful article on BrentOzar.com by Kendra Little. In the comments, Aaron Morelli mentioned that...
2013-11-11
430 reads
How SQL Server Full Backups Work
I’m writing this in support of a few talks I give that talk about backups. This is how I see...
2013-11-11
893 reads
Last Weeks Top “Reading” Links #57
Monday morning and it’s time for weekly round-up. If you follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet...
2013-11-11
1,159 reads
My SQLRally Experience
The past week I had the pleasure to attend SQLRally Amsterdam.
I took a flight from Tel-Aviv to Amsterdam and got...
2013-11-11
768 reads
Notes From SQLSaturday #248
For once the drive from Orlando to Tampa went smoothly, no delays due to accidents or construction or UFO’s, a...
2013-11-11
604 reads
PASS Data Architecture VC presents Steve Simon–Challenges to Designing Financial Warehouses
Please join the Data Arch VC with Steve Simon this Thursday Nov 14th at noon central for a great look...
2013-11-11
611 reads
PowerShell – Service Comparison GUI Tool
Service Comparison GUI Tool does comparison of all the services of any given two servers. The output is a grid view...
2013-11-11
1,679 reads
Blogs
A New Word: los vidados
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
In-Person CISA Training – April 13-16, 2026
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
EightKB 2026
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
Forums
Vectors in SQL Server 2025
Comments posted to this topic are about the item Vectors in SQL Server 2025
Odd Sequences
Comments posted to this topic are about the item Odd Sequences
Everything is the right question away
Comments posted to this topic are about the item Everything is the right question...
Question of the Day
Odd Sequences
What values are returned from this code?
CREATE SEQUENCE NumericSequence
AS NUMERIC(5,1)
START WITH 1.0
INCREMENT BY 0.1;
GO
SELECT NEXT VALUE FOR NumericSequence
GO
SELECT NEXT VALUE FOR NumericSequence
GO See possible answers