I'm happy to announce that SQLServerCentral is sponsoring a track at this year's SQL Connections conference in Las Vegas, Nov 9-12, 2009. We're supplying the speakers, and picking the topics. If all goes well, we should be continuing this...
2009-06-05
1,164 reads
Whenever I do a security presentation, I make sure to cover the Principle of Least Privilege. And when I do I boil it down to this very simple definition: Giving the rights to do the job. No more. No less.
2009-06-04
1,912 reads
Kognitio WX2 I went to a presentation by a company called Kognitio which has a super-fast in-memory database engine targeted at the data warehouse market. They have put the Powerpoint...
2009-06-03
1,673 reads
On a couple of recent webcasts, I pointed out the folks were running with the local Administrator account. To start this out, I'm not a big fan of security by obfuscation. Security by obfuscation (not code obfuscation, but security by obscurity, if...
2009-06-02
2,556 reads
The goal of this post is to explain how to take advantage of Auto-Retry and why you will want to use it. I hope to clarify in which circumstances an auto-retry works best and when not to use it also. The (disclaimer!) point is that every job has its own constraints, requirements, and has to be evaluated individually for whether an auto-retry will work. I will try and keep this summary short and crisp, but still with enough detail to understand auto retry best.
2009-06-01
3,877 reads
You have a few options for protecting your SQL Server data at rest. So far I haven't seen anything thing protects data in memory, and I'm not sure we ever will. After all, at some point it needs to be processed, joined, etc., and that can't happen if it's well encrypted.
2009-05-28
1,073 reads
I saw an interesting blog post from Andy Leonard ( @AndyLeonard ) recently on what he thought Twitter was. I'd started my own post here, with some thoughts, and had to go back and rewrite things (Thanks, Andy!). He got me thinking, and I agree, it's...
2009-05-26
3,720 reads
I just finished up my third coaching call with Don Gabor (Part 1, Part 2, Part 3, Part 4) and I think I'm gaining a little ground, but still finding that I have a lot to learn.
2009-05-25
813 reads
I saw this mentioned on Twitter, and watched it while doing some light editing and scheduling. It’s from TechEd 2009 in LA, and includes a number of MVPs and consultants and even a Microsoft SQL Server program manager. It’s a video, running about 55 minutes...
2009-05-22
5,658 reads
I've been reading What Got You Here Won't Get You There by Marshall Goldsmith over the past couple months, and found it to be a useful book. My one sentence summary is that it teaches without the ability to be introspective and let go of your pride,...
2009-05-21
1,793 reads
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
A while back I wrote a quick post on setting up key mappings in...
Comments posted to this topic are about the item Lots of FKs
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Comments posted to this topic are about the item Can You Let Go of...
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers