I just got back from a New England SQL Server Users Group meeting. Andy Leonard (twitter: @AndyLeonard, blog) gave a great presentation on Change Data Capture and SSIS 2008. At the beginning of this week, I posted about things I wish I knew when I started. I tagged a couple people asking them the question … Read more
When I wrote about empirical evidence and learning through trying (instead of asking only), I got thinking about things I wish I knew when I was a Junior DBA that I know now. Rather than just keep those thoughts to myself, I figured I would write about them here and tag a couple folks to … Read more
When I started blogging, my first posts were on shrinking. That’s still a popular search. Why?
Or how I learned to stop asking so much and start trying… Empirical, as defined by Webster: 1.) originating in or based on observation or experience 2.) relying on experience or observation alone often without due regard for system and theory 3.)capable of being verified or disproved by observation or experiment. I think empirical thought … Read more
Have you lost your mind?! What could I possibly mean by that title? I’m a DBA… One of the basic tenets of a DBA is “backup, backup, backup”, right? Well sort of… Far too often I hear people asking questions like “will this setup allow our backups to be fast?”, “how is your backup process … Read more
Reading a blog this week, I learned quite a few new tips and tricks about SQL Server Management Studio. Incremental Serach (No annoying search window pop-up and searches as you type), replace within files from SSMS!!, Block Selects and Moves for the T-SQL Code formatting OCDers (like me). Check it out and add Aaron to … Read more