Getting Windows Authentication to Work Without a Domain
Not every company has Active Directory setup to give them a centralized way of managing authentication. For those who manage SQL Servers within a Workgroup getting authentication to work correctly with Windows logins can be tricky if you haven’t done it before. In order to get Windows logins working correctly the trick is to create […]
Recommended reading from mrdenny for September 12, 2014
This week I’ve found some great things for you to read. These are a few of my favorites that I’ve found this week. Links and resources for understanding windowing functions Making a Difference – #SQLFamily New Middleware Promises Dramatically Higher Speeds, Lower Power Draw For SSDs Ask Slashdot: Tech Customers Forced Into Supporting Each Other? […]
Dangers of Mixing Native Backups and VSS Backups
In today’s modern world of virtualization there are a lot of different ways to backup databases. You’ve got native backups, VSS backups taken by snapshotting the VMs, third party backup tools which take snapshots, etc. When you have multiple backup techniques all being used at once you run the risk of breaking the LSN chain […]
Recommended reading from mrdenny for September 05, 2014
This week I’ve found some great things for you to read. These are a few of my favorites that I’ve found this week. Dude, who owns that #temp table? Edgenet Exec Q&A TechEd 2014 Day 4 How In-Memory Database Objects Affect Database Design: The Conceptual Model Avoiding a split brain in database mirroring This weeks […]