Power BI Workshop Videos
I’ve created a series of five tutorial videos for a set of workshops I’ll be doing at several events this...
2015-01-29
674 reads
Blog Posts
SQL Judo’s Monthly Challenge – February 2014 – KILL with the DAC
Every month SQL Judo (Russ Thomas) (b/t) challenges us to do his Monthly DBA Challenge. I’ve decided it would be...
2015-01-29 (first published: 2015-01-26)
6,313 reads
SQL- Querying XML attributes from XML Column
Read XML column attributes in to two columns DimType and Dimvalue from the below example also retrieve the data matching...
2015-01-29 (first published: 2015-01-22)
38,611 reads
Trapping Online Index Operations
Recently I wrote an article about Capturing Online Index Operations. In that article, I discussed a problem that I had encountered. Well, there were multiple problems. One was an...
2015-01-29
14 reads
Trapping Online Index Operations
Recently I wrote an article about Capturing Online Index Operations. In that article, I discussed a problem that I had...
2015-01-29
1,335 reads
ASP.Net MVC File Stream, Initiated From Javascript Post
I was recently working on a page that does an AJAX post to an MVC controller passing quite a lot...
2015-01-28
272 reads
Excel BI Tip #17: Using the Timeline Filter
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2015-01-28 (first published: 2015-01-20)
6,937 reads
New Power BI Preview and Pricing
Some exciting announcements were made today about the new Power BI cloud-based business analytics service. Today Power BI is an...
2015-01-28
590 reads
Oh Look, A Horseless Carriage
Never forget, we’re making buggy whips. And everybody we know drives little buggies and they need our buggy whips. We’ve...
2015-01-28
1,090 reads
Out of Space
I’ve used placeholders to ensure I don’t run out of space on my machines. That’s worked well, and usually I...
2015-01-28
1,270 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
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Alamat BCA KCP Surya Kencana Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Suryakencana No.260 C & D, RT.01/RW.05, Babakan Ps., Kecamatan Bogor Tengah, Kota...
Alamat BCA KCP Ketapang Hub/Wa. 0817-819-444
WhatsApp:0817819444 Blok A/3-4, Ketapang Indah, Jl. KH Zainal Arifin, RT.5/RW.7, Krukut, Kec. Taman Sari,...
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