'Every time you backup or restore a database SQL Server keeps history information about the backup or restore operation. The backup and restore information is captured and stored in the msdb database. This backup and restore information if left unchecked can take up more and more space over time. To minimize msdb storage space you need to consider removing the backup and restore history records when they are no longer useful.'...
http://www.databasejournal.com/tips/managing-sql-server-backup-and-restore-history-information.html
'When we are DBAs, we need to deal with files and folders all the time. We need to handle data files, transaction log files, system files, backup filess, log files, external files, BLOBs, etc. PowerShell is a great assistant for help us administering these files. In this article, we will learn the following topics in PowerShell:
-
How to store information from a query to a HTML file.
-
How to create a file with the current date as a suffix in the file name.
-
How to create a directory.
-
How to copy files.
-
How to share a folder.
-
How to compare two files and find the differences.
-
How to merge two files.'...
http://www.sqlservercentral.com/articles/copy/145848/
'Microsoft has added Distributed Transaction Coordinator support, optimized log transport and other features to AlwaysOn Availability Groups in SQL Server 2016.'...
http://searchsqlserver.techtarget.com/feature/Whats-new-in-2016s-SQL-Server-AlwaysOn-Availability-Groups
'Ever wondered how to read the transaction log for a database? There is an undocumented SQL function sys.fn_dblog which may help you to read T-Log except for the truncated transaction details. We can use this function effectively for point in time recovery at a LSN level.
First lets see how the typical output of the function, I have run the function on the AdventureWorks2012 DB,
SELECT * FROM sys.fn_dblog(NULL,NULL)'...
http://www.sqltechnet.com/2016/01/sysfndblog.html
'Question: We had a hardware failure which caused the server supporting the ESX host to crash. The administrator issued a VMotion onto another server in the Cluster. Upon restart the SQL server is recovering very slowly. What can be causing this delay?'...
http://www.sqlserver-dba.com/2012/07/sql-server-recovery-slow-after-hardware-failure.html
'Licensing is always one of the more confusing aspects of any product, and SQL Server 2016 is no exception to that rule. In this post, we’ll take a closer look at the SQL Server 2016 editions and licensing models, as well as examine how licensing works in virtualization and high-availability scenarios.'...
http://sqlmag.com/scaling-success-sql-server-2016/overview-sql-server-2016-licensing
'Hi friends, We need to collect inventory for database migration as well as platform to set up environment for migration, development and testing. Is there any tool from Microsoft to achieve this scenario? Yes, we have Microsoft Assessment and Planning Tool (MAP) for it. From BOL: The Microsoft Assessment and Planning (MAP) Toolkit is an… Continue reading How to collected inventory for SQL Server using Microsoft Assessment and Planning (MAP) tool
'...
http://www.sqlservercentral.com/blogs/kapil-blogs/2016/09/30/how-to-collected-inventory-for-sql-server-using-microsoft-assessment-and-planning-map-tool/
The SQL Server Reporting Services team is pleased to announce the first update for SQL Server Report Builder 2016 is now available in the Download Center.
Download SQL Server Report Builder 2016
This aligns Report Builder with the new rapid release schedule you’ve seen other products like SQL Server Data Tools follow, allowing us to get product improvements to our customers faster than ever. This includes items that are reported to the team via Microsoft Connect, where customers often leave feedback or report product issues they’ve encountered.'...
https://blogs.msdn.microsoft.com/sqlrsteamblog/2016/09/20/sql-server-2016-report-builder-update-now-available/?MC=SQL&MC=Vstudio&MC=CSHARP&MC=.NET&MC=WebDev
