Tag Archives: new features

Joys With Datetimes

Sometimes we need to generate current timestamp in a special format (e.g. suffixes for backup files). If we are unlucky that requested format is not supported by CONVERT function and SQL Server version is 2008 R2 and older this might … Continue reading

Posted in Microsoft SQL Server | Tagged , , , , | Leave a comment

Reporting Services 2012 SP1 on iPad

According to technet article Reporting Services are supported on iOS 6 devices in both (Native and SharePoint integrated) modes since SQL Server 2012 SP1. This was one of the feature I was really looking forward as it would be the … Continue reading

Posted in Microsoft SQL Server | Tagged , , , , , , , , , , , , | Leave a comment

Get first and last day of month in SQL 2012 and SQL 2008 and earlier

This article has been reviewed, improved and moved to my new blog http://blog.hubacek.uk/get-first-and-last-day-of-month-in-sql-2012-and-sql-2008-and-earlier/ Today I had to create an ETL for batch loading of records into data warehouse for the current month. For this I had to get first and last day … Continue reading

Posted in Microsoft SQL Server | Tagged , , , , , , , , , , | 4 Comments

Managed Service Account (MSA) GUI Tool by cjwdev – Windows Server 2008R2 schema

My April’s post about Managed Service Accounts had highest audience at my blog so far. Thanks for that! Chris Wright mentioned that he is working on GUI utility which would make MSA’s creation much easier (at least for guys not … Continue reading

Posted in Managed Service Accounts, Microsoft SQL Server | Tagged , , , , , , , | 1 Comment

… and one more thing … about Managed Service Accounts

Microsoft released hotfix for Windows Server 2008 R2 and Windows 7 fixing password change mechanism. MSA’s passwords are updated by default every 30 days (may be changed in registry at HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\NetLogon\Parameters). When password expires and is changed by computer, Kerberos … Continue reading

Posted in Managed Service Accounts, Microsoft SQL Server | Tagged , , , , , , , , | Leave a comment

Managed Service Accounts with Microsoft SQL Server 2012

Managed Service Accounts (MSA) which came with Microsoft Windows Server 2008 R2 and Windows 7 allow you to create domain account which is tied to a specific computer. The account itself is a hybrid of User and Computer account and … Continue reading

Posted in Managed Service Accounts, Microsoft SQL Server | Tagged , , , , , , , , , | 41 Comments

Free e-book: Introducing Microsoft SQL Server 2012

Today I have come across free e-book Introducing Microsoft SQL Server 2012. Book introduces you into new features of 2012 like High Availability and Disaster Recovery, Security, Integration Services, Data Quality Services, Master Data Services, etc. … Here is the … Continue reading

Posted in Microsoft SQL Server | Tagged , , , , , , , | Leave a comment