SQL Server End-Of-Life Schedule by Microsoft

There are SQL Server end-of-life dates you should be monitoring. Once a system has reached end-of-life you will no longer receive support from Microsoft, and there will be compliance issues as auditors will have issues with unsupported production systems having potential security issues. You should develop a written plan to upgrade existing systems to a supported version, test the plan to verify you won’t have any issues, and implement the plan before your existing systems reach end-of-life.

sqlserver2014

This chart from Microsoft will help you understand the end-of-life dates for the various versions of SQL Server.

Summary
SQL Server 7       - 1/11/2011
SQL Server 2000    - 4/09/2013
SQL Server 2005    - 4/12/2016
SQL Server 2008    - 7/09/2019
SQL Server 2008 R2 - 7/09/2019
SQL Server 2012    - 7/12/2022
SQL Server 2014    - 7/09/2024
Advertisements

SQL Server: List table columns names instead of using SELECT *

Smart and Easy - @SeniorDBA

In SQL Server, and in any common SQL language, the asterisk ( * ) tells the database engine to return all columns within a table. Using “SELECT *” in your queries is a bad idea, and the reasons why we don’t recommend this is:

    • Security – If an unauthorized user gets access to your query and it returns * (meaning all columns)  it could leave every column available for misuse.
    • Performance – It should always be faster to return the data just the columns you need than for all available columns. When using “SELECT *” the column list is resolved each time you run the statement, so it is almost always true that it is faster to return just the columns you need instead of all columns.
    • Confusion – As things change over time, you really can’t be sure that a query written today using “SELECT *” will return results easily digestible by the program or report that must consume the data in the future. Columns may be added or removed to a table over time, and if you specify columns in your SELECT queries you know exactly which ones will be returned.

We know the reason must people use “SELECT *” in a query is because it is easy and fast. So how can we make using the column names easy and fast?There are a few examples that make it extremely easy to list the column names from a table.

Continue reading “SQL Server: List table columns names instead of using SELECT *”

Enabling Windows Defender Application Guard in Windows 10

WDAG - @SeniorDBA

On Windows 10, a relatively new feature called Windows Defender Application Guard (WDAG) allows the user to isolate Microsoft Edge browser at the hardware level using Hyper-V technology. This allows the user to protect the device and data from many malware and zero-day attacks.

Microsoft Edge running in WDAG should provide enterprises the maximum level of protection from malware and zero day attacks. WDAG for Microsoft Edge is a lightweight virtual machine that helps isolate potentially malicious website activity from reaching your operating system, applications, and critical data.

  • Isolated Browsing – WDAG uses the latest virtualization technology to help protect your operating system by creating an isolated environment for your Microsoft Edge session.
  • Help Safeguard your PC – WDAG starts up every time you visit an internet site to help keep potentially malicious attacks away from your PC.
  • Malware Removal – Any websites you visit, files you download, or settings you change while in this isolated environment are deleted when you sign out of Windows, wiping out any potential malware.

Continue reading “Enabling Windows Defender Application Guard in Windows 10”

SQL Server: When Table Data Is Last Accessed And Modified

Statistics - @SeniorDBAKnowing the last time the data was accessed in you database can be helpful information. This script can be used to find when table data is last modified or accessed:

Continue reading “SQL Server: When Table Data Is Last Accessed And Modified”

Output is Better


Happiness

You work hard. You know you work hard, your co-workers know you work hard, and your customers know you work hard. No one cares that you are working hard. What really matters is output. What have you gotten done? It has been shown through numerous studies that people will feel more value in a process that seems more difficult. People feel vacuums are more powerful if they are louder, cars are more powerful if the engine makes more noise, and that software must be really powerful if it took you more than a couple of 10 hour shifts to develop.

But the key to happiness is getting work done without so much effort. One of the things that is supposed to be a benefit of experience is things are supposed to get easier with age. Don’t fool yourself into believing that working harder is working better. What lessons have you learned that can make your job easier? If it is still taking you the same amount of time to do most of your tasks, you have to ask what you are doing wrong.

Continue reading “Output is Better”

Create Bootable USB Drive Using Windows 10

USB Thumb Drive - @SeniorDBA

Creating  a bootable USB may allow you to boot your computer even if the internal hard drive has stopped working. It is also very useful to create a bootable USB drive so you can copy the Windows 10 ISO image onto the USB drive and install Windows 10 with ease. With a new major version of Windows 10 available, maybe now is a good time to review these steps. We have shown you how to create a Kali Linux boot USB using your Mac in a previous post.

If you don’t want to use any special software there is a way to create a bootable USB drive from you Windows 10 Command Prompt, but it can be a bit tricky. Here’s how to do it step-by-step on your computer:

Continue reading “Create Bootable USB Drive Using Windows 10”

Free Download: SQL Server Management Studio 17.6

SQL Server

SQL Server Management Studio (SSMS) is an integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server. SSMS combines a broad group of graphical tools with a number of rich script editors to provide developers and administrators of all skill levels access to SQL Server.

Microsoft has announced the latest release of SQL Server Management Studio (SSMS) in October. This release features improved compatibility with previous versions of SQL Server and a stand-alone web installer.

Get it here:

Continue reading “Free Download: SQL Server Management Studio 17.6”