We all inherit things from time to time through our profession. Sometimes we inherit some good things, sometimes we inherit some things that are not so good. Other times we inherit some things that are just plan annoying. Yet other times, we inherit things that may be annoying and we probably just haven't discovered them yet.
Looking forward to heading to Southern California this weekend for SQL Saturday #120 in Huntington Beach. They always put on a great event and you can’t beat the location. Not to mention that it is very close to where I grew up so I get to see some old friends while I’m there.
I will be […]
This is a bit late but wanted to post about my experience at the recent SQL Saturday held in Omaha, Nebraska. This was a fantastic event, particularly given that it was the first SQL Saturday held in Omaha. It was well-organized, had great sponsor support, and the facility at the University of Nebraska […]
One of the most important tasks for the DBA is managing backup files. Often the SQL Server backups files themselves are written to a drive local to the database server, but we then need to copy them off to a remote share. RoboCopy is a fantastic utility included in Windows that is great at doing […]
One of the issues I often run into is the need to truncate very large tables. But if there is a foreign key constraint on the table, SQL Server will not allow a truncate, only a delete. This is fine for smaller tables but if the table has millions of rows, we want to do […]
Just a quick shout out to a great article on how to Debug CLR Projects.
Headed to Chicago tomorrow for SQL Saturday #67. Heading out a day early to attend a pre-conference seminar on Friday on troubleshooting and performance tuning. While I feel pretty strong in these areas, one thing I haven’t done as good of a job of as I should is keeeping up on new features to assist […]
I’ve been doing a lot of traveling lately speakng at SQL Saturday events. This last weekend it was my great pleasure to speak at Utah Code Camp, a local event. Not only was it nice to be local, but I really enjoyed the code camp. Unfortunately I didn’t get to stay all day as I […]
This discussion came up on Twitter so I thought I’d blog about it. UPDATE FROM (sometimes called an UPDATE JOIN) is an language construct that is an extension to the ANSI-92 standard supported by several DBMS’s, but not by Oracle. I first discovered this when doing some ETL work in SSIS with an Oracle destination. […]
I was asked by a client today to provide 4 bullet points to include in a job description for a developer position that will be primarily responsible for SQL Development. I explained that my preference is to focus on database engine first, then worry about T-SQL. Too many times I see customers who focus on […]