SQL Server – Endpoint Authentication Error in AlwaysOn Availability Group Setup
According to MSDN: If the SQL Server service is running as a built-in account, such as Local System, Local Service,...
2015-02-06
649 reads
Blog Posts
T-SQL Tuesday #62 - Wrap Up!
This month’s T-SQL
Tuesday #62, the first of 2015, hosted by yours truly, (invitation
to Healthy SQL here), asked that you all...
2015-02-06 (first published: 2015-01-29)
7,505 reads
Azure Enhancements – Time to take a look (and read the ebook.)
TweetG’day,
Recently I’ve become quite interested in the latest incarnation of Azure SQL Database.
For those that are unaware of some of...
2015-02-05 (first published: 2015-01-27)
6,549 reads
Enable SSDT and DacFx logging
**Update** I have noticed that these cmd files are missing from recent ssdt builds, to enable logging see Kevin’s comment:
http://blogs.msdn.com/b/ssdt/archive/2014/07/15/sql-server-data-tools-ju…
**/update...
2015-02-05
77 reads
Enable SSDT and DacFx logging
**Update** I have noticed that these cmd files are missing from recent ssdt builds, to enable logging see Kevin's comment:
http://blogs.msdn.com/b/ssdt/archive/2014/07/15/sql-server-data-tools-ju…
**/update I was helping someone get a deployment filter working...
2015-02-05
23 reads
Enable SSDT and DacFx logging
**Update** I have noticed that these cmd files are missing from recent ssdt builds, to enable logging see Kevin’s comment:
http://blogs.msdn.com/b/ssdt/archive/2014/07/15/sql-server-data-tools-ju…
**/update...
2015-02-05
145 reads
How to Enable / Disable Xp_cmdShell in SQL SERVER? TIP #82
Friends,
Sometimes it might be possible that you have to run dos command from SQL SERVER. In such situation you have...
2015-02-05
26,983 reads
Rochester PASS Chapter February Meeting - I'm Speaking!
On Thursday, February 26th at 6:00 PM EST I will be speaking at the Rochester PASS chapter meeting. The topic is “Easing Into PowerShell - What’s It All About?”.
You’ve been hearing a...
2015-02-05
23 reads
Excel BI Tip #18: Using CUBE Functions to Break Out of Pivot Tables
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2015-02-04 (first published: 2015-01-27)
8,134 reads
Some Thoughts About Microsoft’s Cloud Platform Roadmap
There have been a lot of changes in and around Microsoft in the past few months. Under the leadership of...
2015-02-04
454 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