Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

<< Newer    Items 81 to 100 of 13430    Older >>

SQL Server Data Import System to Alert For Missed Imports

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.  Read more...
By Additional Articles 2014/12/31 | Source: | Category: import
Rating: (not yet rated)  Rate this |   Briefcase | 5,220 reads

Create stunning visualizations with Power View in 20 minutes or less!

Learn about Microsoft’s latest end-user BI reporting tool, Power View, and create animated graphs that impress your boss!  Read more...
By Amir Charania 2014/12/30 | Source: | Category: power view
Rating: |  Discuss |   Briefcase | 7,530 reads

2014: The Review

Steve Jones looks back at 2014 from a data perspective.  Read more...
By Steve Jones 2014/12/30 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 101 reads

Database Build Automation – The First Step to Continuous Integration

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.  Read more...
By Additional Articles 2014/12/30 | Source: SimpleTalk | Category: automation
Rating: (not yet rated)  Rate this |   Briefcase | 9,026 reads

Moving On

Today Steve Jones talks about the inevitable event where someone leaves their job.   Read more...
By Steve Jones 2014/12/29 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 183 reads

SQL Server 2014 Checklist for Performance

A checklist to help optimize the performance of SQL Server   Read more...
By Rudy Panigas 2014/12/29 | Source: | Category: performance
Rating: |  Discuss |   Briefcase | 6,764 reads

SQL Server Reporting Services Add Calculated Series to a Graph

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.  Read more...
By Additional Articles 2014/12/29 | Source:
Rating: (not yet rated)  Rate this |   Briefcase | 6,533 reads

Beware the Small Things

Minor disasters can become major ones quickly. 
By Steve Jones 2014/12/29 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 121 reads

SQL Saturday #363 - Nashville, TN

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.  Read more...
By Press Release 2014/12/29 | Source: SQL Saturday | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 5,279 reads

Parsing HTML to SQL using SQLDOM

It is simple to parse HTML directly to SQL, manipulate, and render back to HTML using SQLDOM  Read more...
By David Rueter 2014/12/26 (first published: 2012/04/16) | Source: | Category: html
Rating: |  Discuss |   Briefcase | 14,304 reads

Getting Started with HDInsight - Part 2 - Introduction to Azure HDInsight PowerShell

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.  Read more...
By Additional Articles 2014/12/26 | Source: | Category: powershell
Rating:  Rate this |   Briefcase | 7,078 reads

The Rich Rewards of Tuning SQL

The next time you are tempted to hammer a performance problem with hardware, why not instead invest that time in hammering and refining your SQL queries? There are rich rewards to be had.  Read more...
By Tony Davis 2014/12/26 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 477 reads

Merry Christmas 2014 and Happy Holidays

Holiday wishes from Steve Jones. 
By Steve Jones 2014/12/25 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 96 reads

15 Quick Short Interview Questions Useful When Hiring SQL Developers

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.)   Read more...
By Thomas Kovarik 2014/12/25 (first published: 2013/02/28) | Source: | Category: career
Rating: |  Discuss |   Briefcase | 13,317 reads

SQL Brainteasers: Guess the Christmas Carol/Song

It's Christmas, so here are some Christmassy-themed songs to guess.  Read more...
By Additional Articles 2014/12/25 | Category: puzzle
Rating: (not yet rated)  Rate this |   Briefcase | 6,384 reads

Stairway to PowerPivot and DAX - Level 6: The DAX SUM() and SUMX() Functions

Business Intelligence architect, Analysis Services Maestro, and author Bill Pearson exposes the DAX SUM() and SUMX() functions, comparing and contrasting the two. He then provides some hands-on exposure to the use of each, particularly in combination with other DAX functions, in managing “sum” aggregations within our PowerPivot model designs.  Read more...
By Bill Pearson 2014/12/24 (first published: 2014/08/27) | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 4,357 reads

SQL Server Data Aggregation for Data with Different Sampling Rates

In the emerging "Internet of Things", there are multitudes of devices collecting data at differing sampling rates. Integrating this data so the data has a common granularity in time is important to not only allow for accurate analysis and mining, but it will also aid in reducing the amount of data to be stored and processed. In this tip, we will demonstrate how to use the T-SQL AVG function and GROUP BY clause to transform data collected from two devices sampling at 100Hz and 40Hz to one row per second.   Read more...
By Additional Articles 2014/12/24 | Source: | Category: aggregate transform
Rating: (not yet rated)  Rate this |   Briefcase | 6,877 reads

‘Twas the night before the upgrade…

A Christmas poem for the DBAs. 
By Mike Tutor 2014/12/24 | Source: Other | Category: humor
Rating: |  Discuss |   Briefcase | 46 reads

Free eBook: SQL Server Hardware

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.  Read more...
By Press Release 2014/12/24 (first published: 2013/07/24) | Source: Red-Gate | Category: hardware
Rating:  Rate this |   Briefcase | 38,539 reads

Dealing with the Evil of FMTONLY from SSRS

SSRS continues to use SET FMTONLY ON even though it has many problems. How can we cope?  Read more...
By David Rueter 2014/12/23 | Source: | Category: ssrs
Rating: |  Discuss |   Briefcase | 3,986 reads
<< Newer    Items 81 to 100 of 13430    Older >>