Viewing 15 posts - 1 through 15 (of 55 total)
I use Extended Properties on any new table DDL, and important existing tables, to describe both the purpose of the table and the purpose of the column. When this is...
March 18, 2020 at 4:29 pm
My favorite timestamp is Select Convert(nVarchar(8), SYSDATETIME(), 112) + '_' + Replace(Convert(nVarchar(8), SYSDATETIME(), 114), ':', '')
March 16, 2020 at 4:00 pm
Thanks for weighing in on this subject. It's stupid that I even have to justify the upgrade because we're 4 version out of date, but the bean-counters are not convinced...
February 26, 2020 at 3:29 pm
Thanks for the input. I knew some of this, but not the issues with the Insert BULK, which is not a feature that I really cared about until now. I...
February 26, 2020 at 3:16 pm
Grant, Thanks for the reply. Our Production SQL (prodSQL) is a SQL 2012 instance.
I agree. Don't make uninformed decisions. To that end, I've created an Extended Events session I called...
December 10, 2019 at 12:01 am
I'm hoping that you guys can point a finger in the right direction for me. We're bouncing on the ceiling for CPU utilization for our prodSQL. I'm researching ways to...
December 8, 2019 at 11:32 pm
When describing my role as a DBA to anyone outside of our profession, I tell them that I'm a glorified plumber. I make sure the data pipes are all connected...
May 24, 2019 at 5:30 pm
I am technically competent to be in the Senior SQL Server DBA position that I am in. My work ethic is, I am here to provide the tools, policies, and...
May 24, 2019 at 4:15 pm
AlwaysOn FailOver Clustering (FCI) is associated with Windows Services FailOver Clustering (WSFC). This is a High Availability (HA) scenario where two (or more) servers share a SAN, or WAN, or...
March 15, 2019 at 3:53 pm
It looks like this method isn't going to work for me. I was having such a difficult time recovering the PL/SQL from the object variable that I switched methods...
July 13, 2015 at 10:25 pm
Steve, The PL/SQL I need to use to open the recordset is stored in varchar(max). That is the object text I'm having trouble recovering. Whatever method I use,...
July 13, 2015 at 11:08 am
Look at the Idera SQL Compliance tool.
July 1, 2015 at 10:49 am
I agree wholeheartedly. NoSQL stands for "Not Only SQL". It complements RDBMS platforms, not replaces them. Database engineers need to know NoSQL capabilities and weaknesses, as well as...
March 13, 2015 at 9:41 am
I feel the same way about MongoDB as I do Microsoft Access. It's a great tool for the job it was designed for. The problem comes when people...
March 10, 2015 at 7:24 am
Thanks for the article. This is something I've been meaning to do for awhile, but have been too wrapped up in other work. Now if someone could show me...
December 8, 2014 at 1:54 pm