Create a Named Set with all but one Member in MDX – SSAS
I was trying to create a Named set in SSAS 2008 using the MDX calculations. I wanted to include all...
2013-07-05 (first published: 2013-07-01)
1,694 reads
SQL Server – How to connect to SQL Server when ‘sa’ account is disabled
If you have lost the password for sa account or does not have any administrative account and you are locked...
2013-07-03 (first published: 2013-07-01)
4,178 reads
SQL Server Events in the UK July 2013
Last month saw SQL Relay, Tech Ed, SQL Saturday Dublin, oh and the small matter of a CTP for SQL...
2013-07-01
678 reads
Reblog: June 21 to June 27
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-06-28
1,175 reads
SQL 2014 CTP1, where is my BIDS?
Oh wait sorry, I meant SSDT. Or was it SSDTBI? To avoid confusion about the developer tool to create BI...
2013-06-28
4,505 reads
SQL Server – Understanding ‘sp_spaceused’ Results for Database Size Information
From a recent conversation with a customer, I noticed even some of the experienced DBAs are not very clear about...
2013-06-28
1,623 reads
SQL Server 2014 CTP1 Released
This week has been the week of the release: We’ve had the Visual Studio 2013 Preview and now the SQL Server 2014 CTP1. And that’s just the ones I’m...
2013-06-28
5 reads
SQL Server: Part 2 : All About SQL Server Statistics :Histogram
In the Part 1 about SQL server Statistics, we have discussed about density vector information stored in the the statistics. In...
2013-06-27
16,289 reads
PowerSQL – Different Approaches to Find Free Space in all disk drives
Different ways to find FreeSpace in all disk drives of a given server
T-SQLUsing WMIObjectCountersAll three methods are explained below
This post...
2013-06-27
1,511 reads
Visual Studio 2013 preview available
Wow, Visual Studio 2012 is just out of diapers and here comes the next version!
Microsoft officials released the preview of...
2013-06-27
1,620 reads
Blogs
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers