Category: Microsoft SQL Server

Feed: Databasejournal.com - Feature Database Articles. Author: . What is the current identify column value in my table? You probably have an identity column defined in some, or a lot of your SQL Server tables.  But do you know how to check the identify value information for one of your tables?  If not, then here is how you do it.   To check the last identity value information for your table you can run the following command: DBCC CHECKIDENT ( 'yourtable', NORESEED ); Where yourtable  is set to the table in which you what to check the identity value information.  ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . If you compress your database backups you can save a ton of disk space. But by default compressed backups are not created. In order to create a compress SQL Server database backup when your default is not compressed you need to add the "WITH COMPRESSION" option to your BACKUP command. Not a big deal to do, but if you want to always create a compressed backup it might be better to change the default backup type to be compressed. By doing that all our backup command that forget to add the "WITH ... Read More

Feed: James Serra's Blog. Author: James Serra. I recently made available two more presentations that you might find helpful.  Feel free to download them and present them to others (adding a line that you got them from me is all I ask).  There is a full list of all my presentations with slide decks here.  I continually update all my decks, but unfortunately SlideShare no longer allows you to update decks, so just email me at jamesserra3@gmail.com if you want the latest one. Azure data platform overview Want to see a high-level overview of the products in the Microsoft data platform portfolio ... Read More

Feed: Cloud Data Transformation Software | Matillion. Author: Ed Thompson, CTO; The latest release of Matillion, version 1.38, includes a whole host of new components, new features, and enhancements to make Matillion better than ever before! Upgrade your instance today. For More information on how to upgrade, check out our blog on Best Practices for Updating your Matillion Instance.All Matillion ProductsNew ComponentsVersion 1.38 of Matillion introduces a new data staging component for all Matillion products:Sharepoint Query componentNew FeaturesWe are happy to introduce a host of new features that will make your user experience of Matillion even better!Project and Environment UI ... Read More

Feed: James Serra's Blog. Author: James Serra. Azure Data Explorer (ADX) was announced as generally available on Feb 7th.  In short, ADX is a fully managed data analytics service for near real-time analysis on large volumes of data streaming (i.e. log and telemetry data) from such sources as applications, websites, or IoT devices.  ADX makes it simple to ingest this data and enables you to perform complex ad-hoc queries on the data in seconds – ADX has speeds of up to 200MB/sec per node (currently up to 3 nodes) and queries across a billion records take less than a second.  A ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . Microsoft first introduced backup compression in SQL Server 2008. With backup compression you can speed up our backups, while making your backups smaller. While this sounds good, keep in mind compression doesn't come for free. SQL Server requires more CPU to compress a backup then not to compress a backup. The reason compressed backups run faster is because the backup blocks are compressed therefore more of your database can be writing to a backup file with each I/O operation. Because less I/O is performed your backups run faster, and they are smaller ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . Have you ever wondered how much progress SQL Server has completed while rebuilding or creating an online resumable index?  If so, then there is SQL Server system view that will show you how much progress has been completed on your resumable online index rebuild or creation operation. The system view is named sys.index_resumable_operations. This view will show the progress completed on your online resumable index rebuild operation, if you are running Azure SQL Database, or SQL Server 2017. If you are running the Community Technical Preview (CTP) of Azure SQL Database or ... Read More

Feed: James Serra's Blog. Author: James Serra. Azure Data Lake Store (ADLS) Gen2 was made generally available on February 7th.  In short, ADLS Gen2 is the best of the previous version of ADLS (now called ADLS Gen1) and Azure Blob Storage.  ADLS Gen2 is built on Blob storage and because of that it is a “ring 0” service and is available in all regions.  To create an ADLS Gen2 account, see Quickstart: Create an Azure Data Lake Storage Gen2 storage account.  Note that creating Blob storage or ADLS Gen2 both follow the same process, which is to create a storage account.  The ... Read More

Feed: SQL Server Release Services. Author: SQL Server Engineering Team. We are getting ready to update the SQL Server Management Packs. This includes the existing versioned MPs for 2008-2016, as well as the new version agnostic SQL Server MP for 2012 and up (for more info on the version agnostic MP, see here). Please install and use this public preview and send us your feedback (sqlmpsfeedback@microsoft.com)! We appreciate the time and effort you spend on these previews which make the final product so much better. Please download at: Microsoft System Center Management Packs (Community Technical Preview) for SQL Server 2008-2016 Microsoft System ... Read More

Feed: SQL Server Integration Services (SSIS) Official Blog. Author: Sandy Winarko. Expanding our efforts to integrate SQL Server Integration Services (SSIS) deeper into Azure Data Factory (ADF), we have recently improved the configurability of Execute SSIS Package activities in ADF pipelines. With the enhanced “Settings” tab and additional three new tabs (“SSIS Parameters”/”Connection Managers”/”Property Overrides”), you can now configure Execute SSIS Package activities via ADF User Interface (UI) as easily/intuitively as you can configure SSIS package executions via SQL Server Management Studio (SSMS) UI. For comparisons, here is the existing SSMS UI for configuring SSIS package executions: And here is ... Read More