Azure SQL Data Warehouse uses SQL to query the data, but there are some differences to SQL Server's dialect of TSQL, and queries don't necessarily work in the same way. DBAs are also required to use SSDT to access Azure SQL Data Warehouse. It is worth taking the time to try the preview of the product, and take it for a 'spin around the block', following Robert Sheldon's walk-through.
2016-06-21
4,892 reads
2016-06-20
2,985 reads
We are excited to announce the beta release of SQL Compare & SQL Data Compare 12. We want to use this beta period to get as much feedback from you, the SQL community, as possible. Try it out, or for more information on what’s new, read on.
2016-06-20
4,905 reads
Jonathan Kehayias takes a closer look at a new trace flag that allows you to process multiple concurrent statistics updates on the same table.
2016-06-20
2,991 reads
This article presents a utility that will show you what SQL statements are using the transaction logs, in terms of log space used and transaction duration.
2016-06-17 (first published: 2015-03-10)
15,834 reads
In SQL Server Master Data Services all the entities are organized in a model. Once a model is ready to be released to subscribers, it should be frozen and marked as ready for subscribers. Until a model is marked as ready, a model is typically deemed as work in progress. In this article, Siddarth Mehta covers the standard process that's required to release a completed version of the model to subscribers.
2016-06-17
2,721 reads
Knut Jürgensen shares his experiences, both positive and negative, with regard to the function that Master Data Management fulfils within a company. Too often this critical aspect of a business is overlooked or pushed aside without paying it the attention it deserves based on the cost benefits available.
2016-06-16
4,935 reads
SQL Server Hardware will provide the fundamental knowledge and resources you need to make intelligent decisions about choice, and optimal installation and configuration, of SQL Server hardware, operating system and the SQL Server RDBMS.
2016-06-15 (first published: 2013-07-24)
58,113 reads
In the third part of his series on Row Level Security (RLS), Greg Larson shows how to disable RLS for database administrators, sysadmins, and database owners.
2016-06-15
6,385 reads
Paul White discusses the internals of SQL Server's WITH ENCRYPTION clause, and explains why it is not as safe as you might think.
2016-06-14
3,877 reads
A RAG pipeline that answers questions in the demo is not the same thing...
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Comments posted to this topic are about the item Looking for New Blood
Telp/WA 62 8218200233 Menara Bidakara, Jl. Gatot Subroto No.Kav.71-73 Lt. Lobby dan Lt. 1,...
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers