'Pinal, how do I know if a Bulk Logging operation was performed on my SQL Server. I know there are a number of SSIS jobs that run during the day and night and I have a number of log backups that are taken continuously. Some of these jobs actually change the recovery model to Bulk-Logged and end of the process, they turn it back to Full once the script was to end. I know I can do a number of audit settings to make sure this is captured. But is there any other way to identify which of these logs when taken have the Bulk logged operation?'...
http://blog.sqlauthority.com/2016/03/31/sql-server-finding-bulk-logging-enabled-logs/
'This blog shows simple example about creating linked server. There is a provider called PGOLEDB which can be used for this purpose.'...
http://blog.sqlauthority.com/2015/11/24/sql-server-how-to-create-linked-server-to-postgresql/
'There are situations when you need to integrate SQL Server with other product. Once of the classic example was seen during my last visit to a client. They wanted list of email addresses and phone numbers for all users in the company to be fetched by Active Directory. I have told them that SQL can read that data via linked server. Here are the steps to learn how to query active directory data.'...
http://blog.sqlauthority.com/2016/03/30/sql-server-query-active-directory-data-using-adsi-ldap-linked-server/
'Database Instant File Initialization was added several SQL Server releases ago. The instant file initialization feature scales the creation and expansion (growth) of database, DATA files. The ‘Manage Volume Privilege’ option is off by default preventing many SQL Server installations from taking advantage of the feature.
SQL Server 2016 Setup provides the option to enable ‘Perform Volume Maintenance Task’ privilege to the SQL Server Service SID. This privilege enables instant file initialization by avoiding zeroing of data pages. For security and performance considerations see Database Instant File Initialization topic.'...
https://blogs.msdn.microsoft.com/psssql/2016/03/25/sql-2016-it-just-runs-faster-instant-file-initialization/
http://www.sqlskills.com/blogs/erin/instant-file-initialization-easier-to-enable-in-sql-server-2016-and-some-updated-numbers/
'We are getting ready to release the next versions of SQL Management Packs as well as new MPs for SQL Server 2016. In this Community Technology Preview release, we hope to bring you the changes planned now so that with your feedback we can make the final release the best it can be.'...
https://blogs.msdn.microsoft.com/sqlreleaseservices/system-center-management-pack-for-sql-product-family-community-technology-preview-ctp1/
'TITLE: Microsoft SQL Server Management Studio
——————————
Restore failed for Server ‘SQL_SERVER’. (Microsoft.SqlServer.SmoExtended)
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
Database ‘DB1′ cannot be started in this edition of SQL Server because part or all of object ‘object1′ is enabled with data compression or vardecimal storage format. Data compression and vardecimal storage format are only supported on SQL Server Enterprise Edition.
Database ‘DB1’ cannot be started because some of the database functionality is not available in the current edition of SQL Server. (Microsoft SQL Server, Error: 909)'...
https://blogs.msdn.microsoft.com/sqlserverfaq/2010/09/03/how-to-identify-compressed-tables-before-restoringmigrating-database-to-any-edition-other-than-enterprise-edition-of-sql-server-2008/
'I’m starting to catch up on some of my backlog this month. One of the items on my list has to do with FileTables. I wrote about inserting files into a SQL FileTable a while back. I gave an example how to do it with a TSQL script. In demos I showed how you could move files around through Windows Explorer. This post is how to do the same thing through another script.'...
http://www.pertell.com/sqlservings/archive/2015/08/moving-a-filetable-file-from-one-directory-to-another-with-tsql/
'We asked you to pick theme songs to play when SQL Server has issues, and holy cow, you sent in a ton of submissions'...
- Best Song to Play During a Server Outage
- Best Song to Illustrate Your Predecessor’s Skills
- Best Song to Accompany an Index Rebuild
- Best Song to Play When Examining a Slow Query
- Best Song to Play When Corruption is Found
- Best Song for a SQL Server with 4GB RAM
- Best Song to Play While a Cursor Runs
- Best Song to Prepare for a SQL Server Service Pack
https://www.brentozar.com/archive/2016/03/announcing-sql-server-theme-song-winners/
'If you are on SQL Server 2014 and above and have tempdb problems, SQL Server In-Memory OLTP Program Manager Jos de Bruijn just posted a great blog titled “Improving temp table and table variable performance using memory optimization”. While methods documented in https://support.microsoft.com/en-us/kb/328551 are sufficient to most scenarios, some high workloads may continue experience tempdb issues including blocking on system tables. '...
https://blogs.msdn.microsoft.com/psssql/2016/03/25/solve-your-tempdb-problems-with-memory-optimized-tables/
'Everything you want to know about SQL Server 2016 SQL Server Analysis Service. In this session we will look at how Analysis services tabular models simplify solving complex business problems using over 50 new DAX functions and how new relationship types can help solve many to many issues. At the same time improved performance allows faster loading and analyzing of data. Finally updated tools allow for increased BI developer productivity and ease of use in Visual Studio 2015.'...
https://blogs.msdn.microsoft.com/analysisservices/2016/03/25/on-demand-webinar-whats-new-for-sql-server-2016-analysis-services-available-now/