In this tip we will look at two different ways of creating an HDInsight Cluster: Creating an HDInsight Cluster through Azure Management Portal, and creating an HDInsight Cluster through Windows Azure PowerShell.
2015-01-01
6,840 reads
In this tip Tim Smith looks at how to set up a system that allows automatic notification if a process doesn't import new data into SQL Server.
2014-12-31
6,405 reads
So you're keen to take the first steps to the continuous integration of your database. You have to start by getting your database into source control. You can then begin to automate your build processes in order to generate and test a database. By doing this regularly, you'll be much better prepared for the deployment process because you'll have solved integration issues when they happen, and facilitated the broader testing process.
2014-12-30
9,861 reads
A checklist to help optimize the performance of SQL Server
2014-12-29
8,766 reads
SQL Saturday is coming to Nashville on January 17 for a free day of SQL Server training and networking. There will also be paid-for pre-cons to this event on Thursday and Friday, so register while space is available.
2014-12-29
6,434 reads
In order to analyze the data in a line chart better, we want to add trendlines to the graph, such as a weighted average. Here's how to add a "calculated series" to a line chart easily in SQL Server Reporting Services.
2014-12-29
7,422 reads
It is simple to parse HTML directly to SQL, manipulate, and render back to HTML using SQLDOM
2014-12-26 (first published: 2012-04-16)
19,260 reads
PowerShell is a very popular and powerful feature in the Microsoft stack. It is extensively used for development, deployment and administration across various ecosystems like SQL Server, SharePoint, Azure Cloud and others. PowerShell cmdlets are available for HDInsight as well and in this tip we will take a look at fundamental aspects of Microsoft Azure PowerShell for HDInsight.
2014-12-26
7,675 reads
Here is a useful exam that you can administer in either 10 or 15 minutes, either oral or written, when you interview for hiring permanent or contract workers for jobs in SQL Server development or support. (This is not a test for SQL Data Base Administrators.)
2014-12-25 (first published: 2013-02-28)
15,737 reads
It's Christmas, so here are some Christmassy-themed songs to guess.
2014-12-25
6,956 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...
I've got a web application for my side business. I've added a SQL Server...
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...
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers