SQL Server Partitioning 101
I’ve worked with partitioning for quite some time now, and though it has been around for quite some time and lots has been written about the concept I recently...
2014-04-23
9 reads
Richie Lee
2013-12-10
8 reads
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
6 reads
UK SQL Relay 2013 R2 Plus Travel Info for London and Southampton
Throughout November, SQL Relay R2 2013 is taking place in the UK. This is the 2nd series of events this year. SQL Relay is a series of 1 day...
2013-11-04
6 reads
SQL Server 2014 CTP2 Available to Download
At the PASS Summit keynote today Quentin Clark announced that SQL Server CTP2 (which is public and the last public review) and is available right now to download here....
2013-10-16
14 reads
SQL Server Analysis Services Activity Viewer 2012 1.1 Stable Released
This morning I am happy to announce the release of a stable version of SSAS Activity Viewer 2012. The build number is 1.1.0.0. The new features have been highlighted...
2013-10-10
7 reads
SQL Server Analysis Services Activity Viewer 2012 1.0.0.1 Beta Released
(Worth noting that there is a more recent version available here!)
Hi all, yesterday morning I created a project based on an old blog post Upgrade Analysis Services Activity Viewer...
2013-10-04
5 reads
Get The Backup History for Databases
Below is a script that I use to find the backup history for all the databases on a single instance. There is an inline ‘WHERE’ clause that is currently...
2013-10-03
3 reads
SQL Server Hardware and Storage Links
Being a DBA is more than just knowing about SQL: it’s about the technology which SQL runs on, which includes servers and storage. I’m naturally interested in hardware, so...
2013-09-24
2 reads
Extract DacPac Using Command Line
When extracting Dacpacs it’s quite straightforward to go through the UI and extract, however what if you want to do this for more than one database, or automate the...
2013-09-19
52 reads
Blogs
Learn Better: Pause to Review More
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Azure SQL Managed Instance Next-Gen: Bring on the IOPS
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
SQL, MDX, DAX – the languages of data
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Forums
Two foreign keys to the same table. Can't cascade deletes.
Not sure if this is really a relational theory question but it seems about...
Connecting Power BI to SSAS and effective user not working
Hi everyone, Below is a consolidated summary of what we validated Architecture & data...
High Availability setup - has anyone seen this method?
Hi all, I recently moved to a new employer who have their HA setup...
Question of the Day
Encoding URLs
I have this data in a SQL Server 2025 table:
CREATE TABLE Response ( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY , ResponseVal VARBINARY(5000) ) GOIf I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use? See possible answers