SQL Server 2022 brings some exciting new language features such as DATE_BUCKET https://learn.microsoft.com/en-us/sql/t-sql/functions/date-bucket-transact-sql?view=sql-server-ver16 As per the information, this function returns the date-time value corresponding to the start of each date-time bucket. This means it much easier and more readable now
As some of you may be aware I’ve been heavily involved in using Azure Data Factory Mapping Data Flows and have been impressed by it since day one. Its grown and grown since then and is now in General Availability!
Well Azure SQL Database Long Term Backup Retention is now in Public Preview. This allows us to keep out backups now for up to 10 years which may meet your compliance criteria better then the offerings beforehand and certainly may
Subsequent to my post where we’d covered some Windows Server Clustering PowerShell Commands I thought I’d add the two most useful ones I use. This one shows us whether the Witness has a vote or not: Get-Cluster | Format-Table Name,
Last year I was able to attend SQL Saturday in Copenhagen, Denmark and had a fantastic time both during and outside the event. I made new friends and met them many times again during other SQL Saturday events in the
As you may know I’ve been very impressed with Storage Spaces in Windows. With the new Storage Tiering in Windows Server 2012 R2 Microsoft have just included a must have feature.Simply install a few (or one) standard HDD’s and one or
The MCSA: Windows 8 and MCSA: Windows Server 2012 have now been updated as per the post on born to learn at: http://borntolearn.mslearn.net/btl/b/weblog/archive/2014/01/09/mcsa-windows-8-and-mcsa-windows-server-2012-exams-to-be-updated-january-28-2014.aspxSome of the new features are fantastic such as storage tiering and PowerShell Desired State Configuration.
SQL Server 2014 CTP2 is now available at http://technet.microsoft.com/en-US/evalcenter/dn205290.aspx
Sometimes when your SQL Server Agent jobs fail you don’t want them to run again, It’s a simple extra step to disable the job. Firstly create a new job step to disable the job, perhaps called DISABLE JOB STEP and