Four Big Things PASS Could Do Next Year
Here’s my wish list:
Fix the membership problem. One voter, one vote. That’s what we want. The current hack of requiring...
2014-09-25
745 reads
Installing SQL Server 2014 Language Reference Help from disk
Some weeks ago I had to wipe my machine and reinstall everything from scratch, SQL Server included.
For some reason that I...
2014-09-25
977 reads
The BaCON Debacle, or Who’s Mike?
Who is Mike in the business intelligence/analytics world?
Is it Mike White? If it is, he’s the guy I call for...
2014-09-25
1,074 reads
A Bad Day with Backups
I learned a hard lesson when I first started as a DBA. Although to be honest, it’s not a lesson...
2014-09-30 (first published: 2014-09-25)
7,259 reads
SQLSaturday Orlando Marketing Plan-Part 47
Notes:
We sent out a final you haven’t paid for lunch reminder on Wed, asked for a reply if they were...
2014-09-25
491 reads
An Amazing Conference
I said that I’d write about some good things PASS does, and I’ll make it a point to do so....
2014-09-29 (first published: 2014-09-25)
6,908 reads
Convert UK Postcode to Latitude/Longitude/Northing/Easting using SQL CLR
Just a quick post this time. I had a requirement to convert a small number of UK based postcodes to...
2014-09-25
1,131 reads
Convert UK Postcode to Latitude/Longitude/Northing/Easting using SQL CLR
Just a quick post this time. I had a requirement to convert a small number of UK based postcodes to...
2014-09-25
2,619 reads
Presto Chango
About six months ago, I wrote a post reviewing a book titled The Phoenix Project. In that post, I compared...
2014-09-25
502 reads
SQL Server 2014 Cardinality Estimator
SQL Server 2014 Cardinality Estimator
The SQL Server 2014 cardinality estimator has been improved to increase the quality of SQL Server query...
2014-09-25
1,003 reads
Blogs
The #MS_DatabaseConnector## Role: #SQLNewBlogger
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
Asking for Help Isn’t a Weakness
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
The Proof of the Backup Is in the Pudding
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
Forums
The ##MS_DatabaseConnector## User
Comments posted to this topic are about the item The ##MS_DatabaseConnector## User
Planning for Change
Comments posted to this topic are about the item Planning for Change
Importing Excel files into SQL Server, Azure Edition
Comments posted to this topic are about the item Importing Excel files into SQL...
Question of the Day
The ##MS_DatabaseConnector## User
On SQL Server 2025, I run this code as a sysadmin:
CREATE LOGIN Demo WITH PASSWORD = 'Demo1234567' GO ALTER SERVER ROLE ##MS_DatabaseConnector## ADD MEMBER Demo GOI then login as Demo and run this:
USE sandbox go SELECT CURRENT_USERWhat is returned? See possible answers