Azure SQL Data Warehouse is an obvious first-step towards migrating on-premise organisational data to the cloud. So how do you get started with it? Robert Sheldon provides a simple guide that should provide you with sufficient of the the basics you need to get a SQL Data Warehouse database up and running.
2016-05-02
3,466 reads
Learn about Microsoft’s latest end-user BI reporting tool, Power View, and create animated graphs that impress your boss!
2016-04-29 (first published: 2014-12-30)
13,005 reads
We're always looking for articles, but here are a few ones that I'd like to see written up.
2016-04-29 (first published: 2014-09-04)
1,989 reads
Developers who are already familiar with application languages will be baffled by different aspects of PowerShell to the beginner to programming. Laerte recalls his initial struggles with PowerShell and answers those questions he wished he'd found quick answers to.
2016-04-29
4,782 reads
In this article, Marcin Policht describes the basic functionality and implementation steps for Azure SQL Database's Elastic Database jobs.
2016-04-28
5,096 reads
In this new article, we will show how to use the SSIS term lookup transformation tool.
2016-04-27
2,005 reads
Manvendra Singh explains step by step how to change the server level collation setting for an existing SQL Server instance.
2016-04-27
3,428 reads
Using Resource Governor on a SQL Server that suffers from CPU contention thus allowing us specify limits on the amount of CPU that an incoming request can use.
2016-04-26
3,839 reads
In theory, it is easy to determine whether data is equal to, greater than or lesser than a value. Real-world data types can be surprisingly tricky, even for gauging data equivalence. Because SQL cannot remain aloof from any application's data types, you need to be aware of the ways and pitfalls of individual datatypes and how you can test for equality, equivalence, similarity, identity and all that jazz. Joe Celko discusses.
2016-04-26
4,566 reads
With SQL Powershell, you can check all your database backups in minutes, whether you have ten SQL servers or 100.
2016-04-25
5,533 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
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers