Best Practices For Building Alerts for Using APIs with SQL Server
Tim Smith shares some ideas about how to handle and alert on irregular data coming from APIs when loading your database.
2016-09-14
3,377 reads
Additional Articles
Direct Query with Power BI
Power BI allows you to connect directly to the data just as if it were a “standard” connection, and modify and extend the data to support analytics. By using DirectQuery, you can build reports based on extremely large datasets where re-importing data not a practical solution. It also allows you to do data aggregations on the server. There are, of course, restrictions as well but it is nevertheless a worthwhile technique to use where appropriate. Adam Aspin explains all.
2016-09-13
4,392 reads
Real-time Operational Analytics in SQL Server 2016 - Part 1
Arshad Ali takes a look at traditional analytics architecture, the challenges it faces, and how the newly introduced Real-time Operational Analytics feature overcomes those challenges.
2016-09-12
3,683 reads
How to tell what SQL Server version you are running
Gerg Robidoux demonstrates a couple of methods for determining which version of SQL Server you're running, as well as what service pack or hotfix is installed.
2016-09-09
4,482 reads
Azure SQL Database – How to Choose the Right Service Tier
So you've decided to use Azure SQL Database. You head for the portal and are suddenly faced with a number of questions. Sure, the choices you make have a number of repercussions, but what are they? Murilo Miranda provides a simple guide to get started.
2016-09-08
3,876 reads
Introduction to SQL Server Stretch Database
In many cases Azure SQL Database offers an economically and functionally viable alternative to SQL Server deployments. However, there are also scenarios where we might discover that rather than serving as a replacement, it provides synergy, working side by side with your on-premises databases. One of technologies that illustrate this paradigm is Stretch Database, introduced in SQL Server 2016. Marcin Polichtdescribes its basic characteristics and reviews its implementation steps in this article.
2016-09-07
4,849 reads
Minimizing impact of widening an IDENTITY column – part 4
Aaron Bertrand continues his series on widening an IDENTITY column, showing how he would attack the problem directly.
2016-09-06
3,348 reads
The Exploratory Testing Chrome Plugin
If all your application testing is done by test experts, who know how to record images, do screen-capture, write issue-reports to TFS more appropriate and consistent format and so on, you probably don't need the 'Exploratory Testing' chrome plug-in. Otherwise, it is worth checking out Ambily KK's walkthrough.
2016-09-05
3,633 reads
Master Data Management (MDM) Using SQL Server
So many of the problems that organisations have with their IT applications are due to the struggle with data, in the absence of overall organization-wide control and supervision of data and its progress through the various parts of the organization. Master data management (MDM) offers a solution to the many data woes by controlling data change, It does it in an analogous way to Version Control, so that changes are cleansed, checked, tracked and audited, and any named version can be published to other services. Now Microsoft has an implementation as part of the data platform.
2016-09-02
4,892 reads
New Drop If Exists Syntax in SQL Server 2016
When writing T-SQL code, we often write code to check if the database object exists first and then take some action. In this tip John Miner covers the new and easier way to do this in SQL Server 2016.
2016-09-01
7,255 reads
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
Radius Latitude Longitude
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
degree of parallelism
Team, I'm trying to figure out what will be the best recommendation to configure...
A Fun Computer Quote
Comments posted to this topic are about the item A Fun Computer Quote
Question of the Day
A Fun Computer Quote
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers