data-konzept

'The SQL Server Data Tools team is pleased to announce an update for SQL Server Data Tools (SSDT) is now available. The SSDT 16.4 release adds support for Schema Compare in SqlPackage.exe and as an API, Integrated Workspace Mode for SSDT Tabular, and as usual has various bug fixes.

Update: SSDT 16.4.1 Hotfix release is available. This includes a fix for Connect Issue 3104154 to ensure Database Unit Tests work as expected.

Get it here:

Download SSDT GA 16.4.1 for Visual Studio 2015 and Visual Studio 2013

• The version number for GA in Visual Studio 2015 is 14.0.60923.0 (Direct link: https://msdn.microsoft.com/en-us/mt186501)

• The version number for GA in Visual Studio 2013 is 12.0.60923.0 (Direct link: https://msdn.microsoft.com/en-us/dn864412)

This release will be available through Visual Studio Extensions and Updates notification soon.'...

https://blogs.msdn.microsoft.com/ssdt/2016/09/20/sql-server-data-tools-16-4-release/

'Hey, I need sysadmin access to ServerA.

Ok. Why do you need sysadmin?

Well I need to be able to read and write to all of the tables on DatabaseA.

No problem. I’m going to add you to the db_datareader and db_datawriter roles on DatabaseA. Done.
So, why do you need sysadmin?'...

https://sqlstudies.com/2016/03/10/you-dont-need-to-be-a-sysadmin/

'Recently I delivered a demo on Policy Based Management for a customer.   To show this off well, I really wanted to have a larger number of SQL servers to show how PBM can be used to manage SQL Server sprawl.  I can only fit a few VMs in my laptop and Azure would burn though my $150 MSDN credit too quickly, so I decided to look for other options.    I then remembered that SQL Server supports up to 50 instances on the same machine.    

I’m too lazy to click Next  > Next > Next that many times, so I made a script to automatically install 50 instances of SQL on the same machine.

!!WARNING!!! –   This will blow up the size of your SQL install directory significantly!  (about 1GB per instance with SQL 2016).   Do not run this on production servers or any server that you even remotely care about!'...

https://blogs.msdn.microsoft.com/sql_pfe_blog/2016/08/17/quickly-create-a-lot-of-sql-instances/

cls
@echo off

SET ADMIN_ACCOUNT1="CHARLIE\Administrator"
SET ADMIN_ACCOUNT2="SQL2016-1\Administrator"
ECHO: 
ECHO: 
ECHO:    !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
ECHO:    !  THIS WILL INSTALL 50 Instances of SQL         !
ECHO:    !  Ctrl-C to cancel!!  Any other key to continue !
ECHO:    !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
ECHO: 
ECHO: 
pause

FOR %%I IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50) DO (START /wait D:\Setup.exe /q /ACTION=Install /FEATURES=SQL /INSTANCENAME=inst%%I /SQLSVCACCOUNT="NT SERVICE\MSSQL$inst%%I" /SQLSYSADMINACCOUNTS="%ADMIN_ACCOUNT1%" "%ADMIN_ACCOUNT2%" /AGTSVCACCOUNT="NT SERVICE\SQLAGENT$inst%%I" /IACCEPTSQLSERVERLICENSETERMS)

'How to Deal with Corruption In SQL Server Database ?

Backups are evidently a DBAs foremost approach when caught in a critical crisis condition. However, there are instances where responding to corruption is a part of dealing with it besides just leaving the server in the affected state and restoring from a backup. Doing this prevents the condition from worsening leaving scope of database maintenance. Corruption is not the end of the situation and there is a sequential order of dealing with the situation, which can save your database from surfacing severe loss. The segment puts light on some of such tips straight from RDBMS experts for the DBAs, in order to help them understand how important ‘carefully’ responding to corruption in SQL Server is, besides just recovering from it. In this approach we will look on some crucial steps which can be helpful in recovering a corrupt SQL Server database.

Steps to Recover a Corrupt SQL database?'...

http://www.sqlserver-dba.com/2016/08/7-essential-steps-to-recover-a-corrupt-sql-server-database.html

'Another tip for newcomers to SQL. Everybody knows how easy it is to group by month of the year, but what if you get a request for totals by 28 or 30 day periods starting January 1st? There is no handy DATEPART() parameter that can produce these for you. But don’t worry. There is a way that is just as easy.'...

http://www.sqlservercentral.com/articles/Date+Manipulation/145336/

'Service Pack 2 for SQL Server 2014 was released last month (read the release notes here) and includes a new DBCC statement: DBCC CLONEDATABASE.  I was pretty excited to see this command introduced, as it provides a very easy way to copy a database schema, including statistics, which can be used for testing query performance without requiring all the space needed for the data in the database.  I finally made some time to test out DBCC CLONEDATABASE and understand the limitations, and I have to say it was rather fun.'...

https://sqlperformance.com/2016/08/sql-statistics/expanding-dbcc-clonedatabase

'This Simple script will help you to do a Server wide search for an object name or usage of a String in Object Code like Function, Procedure, Views.

Just Type in the Text to Search or Object Name to find against the Parameter @SearchText and Execute.

The output will be in a Tabular format with the Server Name, Database Name, Object Name, Object Type and It First Occurance ( within the procedure/ View/ Function Codes).

Make sure you have access to the Object Code before Executing the script to search'...

http://www.sqlservercentral.com/scripts/Object+Search/145653/

'Dear Customers,

The 2nd cumulative update release for SQL Server 2016 RTM is now available for download at the Microsoft Downloads site. Please note that registration is no longer required to download Cumulative updates.

To learn more about the release or servicing model, please visit:

• CU#2 KB Article: https://support.microsoft.com/en-us/kb/3165264

• Understanding Incremental Servicing Model for SQL Server

• Microsoft® SQL Server® 2016 RTM Latest Cumulative Update: https://www.microsoft.com/en-us/download/details.aspx?id=53338

• Update Center for Microsoft SQL Server: http://technet.microsoft.com/en-US/sqlserver/ff803383.aspx'...

https://blogs.msdn.microsoft.com/sqlreleaseservices/cumulative-update-2-for-sql-server-2016-rtm/

'Dear Customers,

The 5th cumulative update release for SQL Server 2012 SP3 is now available for download at the Microsoft Downloads site. Please note that registration is no longer required to download Cumulative updates.

To learn more about the release or servicing model, please visit:

• CU#5 KB Article: https://support.microsoft.com/en-us/kb/3180915

• Understanding Incremental Servicing Model for SQL Server

• Microsoft® SQL Server® 2012 SP3 Latest Cumulative Update: https://www.microsoft.com/en-us/download/details.aspx?id=50733

• Update Center for Microsoft SQL Server: http://technet.microsoft.com/en-US/sqlserver/ff803383.aspx'...

https://blogs.msdn.microsoft.com/sqlreleaseservices/cumulative-update-5-for-sql-server-2012-sp3/

'Dear Customers,

The 14th cumulative update release for SQL Server 2012 SP2 is now available for download at the Microsoft Downloads site. Please note that registration is no longer required to download Cumulative updates.

To learn more about the release or servicing model, please visit:

• CU#14 KB Article: https://support.microsoft.com/en-us/kb/3180914

• Understanding Incremental Servicing Model for SQL Server

• Microsoft® SQL Server® 2012 SP2 Latest Cumulative Update: https://www.microsoft.com/en-us/download/details.aspx?id=50731

• Update Center for Microsoft SQL Server: http://technet.microsoft.com/en-US/sqlserver/ff803383.aspx'...

https://blogs.msdn.microsoft.com/sqlreleaseservices/cumulative-update-14-for-sql-server-2012-sp2/