The Hammer

The Hammer

  • Home
  • Subscribe
  • Connect to SQL Server on Azure VM via Local SSMS

    Connect to SQL Server on Azure VM via Local SSMS

    After you provision a Microsoft Azure VM with SQL Server there are a few more steps that you need to take to make remote connections. The procedure below starts with a fresh Azure VM provisioned and walks through the process of establishing a connection via SQL Server Management Studio, installed on an on-premises work station. […]

    November 10, 2015
  • SQL PASS Summit 2015

    SQL PASS Summit 2015

    Another amazing PASS Summit week is complete and I am sitting in SEA-TAC airport, waiting for my flight back to the east coast (at the time I wrote this). I am going to hop on the red-eye in about an hour so that I will make it home in time to take my daughters, Kayla […]

    November 2, 2015
  • Counting NULLs and sub-sets of data

    Counting NULLs and sub-sets of data

    Quick Tip: Counting NULLs and sub-sets of data You have been asked to produce a chart which will visualize a few data points. Total work orders. Total closed work orders (work orders with EndDate populated). Total open work orders (work orders with a NULL EndDate). Total work orders with excessive scrap material (work orders with […]

    October 13, 2015
  • Help! I am Locked Out of my SQL Server Instance

    Help! I am Locked Out of my SQL Server Instance

    Beginning with SQL Server 2008, local administrators are no longer SQL Server sysadmins by default. Microsoft removed this feature in an attempt to increase security. I agree with the change. The principle of least privilege would imply that even system administrators who handle patching and management of Windows do not require access to the data which […]

    September 15, 2015
  • Building up the PowerShell community

    Building up the PowerShell community

    Last week I involved in a conversation with some SQL professionals who are also skilled with PowerShell. The SQL Server community is used to having a tool to connect them directly to gurus who are dedicated to helping others, the #sqlhelp hashtag on Twitter. We realized that the PowerShell community’s Twitter hashtags are not as […]

    September 10, 2015
  • Policy Based Management Templates – TSQL2sDay #70

    Policy Based Management Templates – TSQL2sDay #70

    T-SQL Tuesday (aka #TSQL2sday) is a monthly SQL Server blogger event started back in late 2009 by Adam Machanic (blog | twitter). The first topic was about Date/Time Tricks. Read the original TSQL2sday call-out. Each month a different SQL Server blogger is the host who announces the topics and performs the round-up. A big thanks goes […]

    September 8, 2015
  • Lone DBA, Lemming or Master of your Domain

    Lone DBA, Lemming or Master of your Domain

    Are you a lone lemming or the master of your domain? Many organizations hire only one database administrator. This lone DBA is in a unique position which can be both rewarding and challenging. I have spent years as a lone DBA and am able to compare the experience to years as a member of two […]

    August 25, 2015
  • Ding Level 3 in My Epic Life Quest

    Ding Level 3 in My Epic Life Quest

    Wahooo! Today is a day to celebrate. I just realized that I have achieved level 3 in my Epic Life Quest. Stay tuned as I work my way to level 4. I plan to include being a Microsoft Certified Solutions Associate and much more, in that level. Level 3 Quests (Completed before Aug. 11th, 2015) Secure […]

    August 19, 2015
  • Do we care about development environment performance?

    Do we care about development environment performance?

    Recently, but not for the first time, I was confronted with a server administrator that didn’t want to allocate more than one vCPU to a SQL Server machine in a development environment. His exact words ring over and over in my head. Do we really care about development environment performance? The short answer is, YES! Two […]

    August 18, 2015
  • Adding Your Entire Enterprise into Red-Gate SQL Multi Script Distribution List

    Adding Your Entire Enterprise into Red-Gate SQL Multi Script Distribution List

    RedGate sells a product call SQL Multi Script. The product allows you to asynchronously execute T-SQL scripts to large quantities of servers. There are a number of useful administrative tasks which can be made easier with this product. One task, however, that is difficult to perform in SQL Multi Script is adding servers to the […]

    August 11, 2015
←Previous Page
1 … 7 8 9 10 11 … 22
Next Page→

The Hammer

Proudly powered by WordPress