Tag Archives: 2012

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

Service Pack 1 for Microsoft SQL Server 2012 released

Final version of Service Pack 1 for Microsoft SQL Server 2012 (11.0.3000.00) was released on 6th November! Download links: List of fixed bugs Release Notes Download Page What I’m really looking forward to is full iPad support for Reporting Services … Continue reading

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

Database Engine and Databases not discovered by SCOM 2012

I have been playing with System Center Operations Manager aka. SCOM 2012 lately. I wanted to setup my lab environment and create my own Management Pack for SQL Server clustered instances. I followed Management Pack for SQL Server 2012 documentation … Continue reading

Posted in Microsoft SQL Server, System Center Operations Manager | Tagged , , , , | 3 Comments

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

… 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

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

Microsoft SQL Server 2012 Express edition

.. has become available for download. Here is the link: http://www.microsoft.com/betaexperience/pd/SQLEXPCTAV2/enus/default.aspx

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