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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,771,122 DBAs, developers and SQL Server users

Rss
Headlines today   December 26, 2014

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: SQLServerCentral.com | Category: html
Rating: |  Discuss |   Briefcase | 11,178 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: MSSQLTips.com | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 3,319 reads
Previous headlines

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: SQLServerCentral.com | Category: career
Rating: |  Discuss |   Briefcase | 10,285 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 | 3,723 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: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,669 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: MSSQLTips.com | Category: aggregate transform
Rating: (not yet rated)  Rate this |   Briefcase | 4,747 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 | 36,300 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: SQLServerCentral.com | Category: ssrs
Rating: |  Discuss |   Briefcase | 3,287 reads

Practical PowerShell Unit-Testing: Mock Objects

Pester allows you to automate the testing of PowerShell scripts. It can test the output of a function as you develop it by validating simple data (scalars) and arrays, and allows you to focus on the one function you want to test by using 'mocking' to fake all the other functions and Cmdlets.  Read more...
By Additional Articles 2014/12/23 | Source: SimpleTalk
Rating:  Rate this |   Briefcase | 4,401 reads

The Big Database Freeze

When a hospital’s mission-critical database fails at Christmas, disaster for the hospital – and its hapless DBA – seems certain. With less than an hour to spare before catastrophe, can the DBA Team save the day? This is a fictionalized true story.  Read more...
By Additional Articles 2014/12/23 (first published: 2014/12/04) | Source: Red-Gate | Category: verify
Rating: (not yet rated)  Rate this |   Briefcase | 13,268 reads
 
Ask SQL Server Central



From the SQLServerCentral Blogs

XQuery – Accessing the Attributes Axis

Working with a sequence of attributes in XQuery is fairly straight forward with the “attribute” axis even if you don’t...  Read more...
By Arthur Olcot 2014/12/26 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 181 reads
Question of the Day

Checking meta data

By Steve Jones 2014/12/26 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 403 reads

What does this code do?


SELECT@Output = @Output + SPECIFIC_SCHEMA + '.' + SPECIFIC_NAME + Char(13) + Char(10)
FromINFORMATION_SCHEMA.ROUTINES
WhereSPECIFIC_NAME COLLATE SQL_LATIN1_GENERAL_CP1_CI_AI LIKE 'sp[_]%'
And SPECIFIC_NAME COLLATE SQL_LATIN1_GENERAL_CP1_CI_AI NOT LIKE '%diagram%'
AND ROUTINE_SCHEMA <> 'tSQLt'
Order By SPECIFIC_SCHEMA,SPECIFIC_NAME  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
SQLexplorer
512 1175 Ten Centuries  
2.
DonlSimpson
485 1543 SSCommitted  
3.
patricklambin
463 1612 SSCommitted  
4.
Shiva N
437 1021 Ten Centuries  
5.
sebmr2
339 782 Right there with Babe  
Latest forum posts