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

<< Newer    Items 21 to 40 of 13868    Older >>
 

Using a Recursive CTE to Generate a List

Learn how to generate lists of column values from multiple rows by grouping and using a recursive CTE. This is a very flexible and easy implementation, compared to using cursors or PIVOT operators.  Read more...
By Svetlana Marinova 2015/06/26 (first published: 2013/07/09) | Source: SQLServerCentral.com | Category: recursive cte
Rating: |  Discuss |   Briefcase | 19,793 reads

Getting Started with Power BI Designer

The Power BI Designer was recently added under the Microsoft Power BI umbrella. Power BI Designer quickly builds reports or dashboards locally and deploys them to the Power BI site. In this article, Arshad Ali demonstrates how to get started with Power BI Designer.  Read more...
By Additional Articles 2015/06/26 | Source: Database Journal | Category: power bi
Rating: (not yet rated)  Rate this |   Briefcase | 3,120 reads

Survey: Development and Test Databases

Unless development happens directly on the production database, every organization will manage one or more development and test instances. Redgate is doing research to learn how development and test databases are managed within organizations. If you’d like to know more about our plans, or are happy to help us understand the problem, please take part in this 3-page survey.  Read more...
By Additional Articles 2015/07/01 (first published: 2015/06/26) | Source: Redgate | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 3,208 reads

Free Webinar: Can you Automate your Ops Away?

Automation - done right - frees you to add real value to your team, but you've got to be careful not to shoot yourself in the foot. Join Brian A. Randell, Grant Fritchey and Steve Jones as they discuss how to get started when automating your database operations, and what activities are ripe for automation!  Read more...
By Additional Articles 2015/06/29 (first published: 2015/06/26) | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 3,203 reads

Learning SQL Server 2012

A collection of technologies and links that will help you learn more about SQL Server 2012.  Read more...
By Site Owners 2015/06/25 | Source: SQLServerCentral.com | Category: sql server 2012
Rating: (not yet rated) |  Discuss |   Briefcase | 175 reads

Learning SQL Server 2014

A list of technologies in SQL Server 2014 that you might want to learn more about.  Read more...
By Site Owners 2015/06/25 | Source: SQLServerCentral.com | Category: sql server 2014
Rating: (not yet rated) |  Discuss |   Briefcase | 202 reads

#SQLNewBlogger

Steve Jones talks about blogging today, how it can help your career, and how easy it can be to get started.  Read more...
By Steve Jones 2015/06/25 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 109 reads

Integration Services, MySql and SET FMTONLY ON

Challenges with integrating MySQL data in an ETL regime and the Amazing FMTONLY trick!  Read more...
By Gerald Britton 2015/06/25 | Source: SQLServerCentral.com | Category: integration services
Rating: |  Discuss |   Briefcase | 2,783 reads

Microsoft Azure Stream Analytics

Azure Stream Analytics aims to extract knowledge structures from continuous ordered streams of data by real-time analysis. It provides a ready-made solution to the business requirement to react very quickly to changes in data and handle large volumes of information. Robert Sheldon explains its significance.   Read more...
By Additional Articles 2015/06/25 | Source: SimpleTalk | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 1,834 reads

SQL Monitor Custom Metric: Memory Used By Ad Hoc Queries Running Once

This metric measures the amount of memory used by the total number of ad-hoc queries that are currently in the plan cache. If the value is high, it indicates memory is being wasted by storing the execution plans of queries that will never be run more than one time.  Read more...
By Press Release 2015/06/25 | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 1,654 reads

Stairway to Advanced T-SQL Level 6: Creating Rows Of Data Using The UNPIVOT Operator

The UNPIVOT operator does just the opposite of the PIVOT operator, which we looked at in the previous level. By using the PIVOT operator we can take multiple rows of data and create as single row as output. The UNPIVOT operator will take values from a single row and will create multiple rows. Microsoft introduced the UNPIVOT operator when they rolled out SQL Server 2005. In this level I will be showing you different examples of how to use the UNPIVOT operator.  Read more...
By Gregory Larsen 2015/06/24 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,776 reads

Byte Me: Stranger Than Fiction

Keep it out of the papers - we don't want to cause a kernel panic.  Read more...
By Bob Lang 2015/06/24 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 378 reads

Free eBook: Performance Tuning with SQL Server Dynamic Management Views

Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA's troubleshooting armory, laying bare previously unavailable information regarding the under-the-covers activity of your database sessions and transactions.  Read more...
By Additional Articles 2015/06/24 (first published: 2013/08/21) | Source: Redgate | Category: performance tuning
Rating:  Rate this |   Briefcase | 60,887 reads

Export SQL Server Reporting Services Report Data into Multiple Excel with Worksheets

Sometimes SQL Server Reporting Services users want to export SSRS reports into Excel with multiple sheets, but when the SSRS report data region (Tablix/Matrix) doesn't have any grouping then all the data will be exported into a single sheet. Ghanesh Prasad explains how to export a SSRS report into Excel with multiple sheets.  Read more...
By Additional Articles 2015/06/24 | Source: MSSQLTips.com | Category: ssrs
Rating:  Rate this |   Briefcase | 1,005 reads

Skill Supply and Demand

Finding staff with the proper skills can be a challenge, and it might be a reason why you choose, or remain with, a particular technology.  Read more...
By Steve Jones 2015/06/23 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 160 reads

Writing Better T-SQL: Top-Down Design May Not be the Best Choice – Part II

A second part to the series by Mickey Stuewe on writing better T-SQL looks at some of the issues of using views in a complex query.  Read more...
By Mickey Stuewe 2015/06/23 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,443 reads

SQL Server Downloads

A list of the free version, tools, and sample downloads.  Read more...
By Site Owners 2015/06/23 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 3,102 reads

SQLXML Bulk Loader Basics

SQLXML isn't exactly new technology, but like the even more venerable BCP, it remains the quickest and most reliable way of heaving large quantities of data into SQL Server databases. SQLXML is very versatile, and once set up is wonderfully reliable ETL system, but isn't trivial to learn. Adam Aspin comes to the rescue with a simple guide.  Read more...
By Additional Articles 2015/06/23 | Source: SimpleTalk | Category: xml
Rating: (not yet rated)  Rate this |   Briefcase | 3,438 reads

The Test of Time

IBM recently turned 100 years old and Steve Jones wishes more companies would try to build their business to grow to 100.  Read more...
By Steve Jones 2015/06/22 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 195 reads

The Case for Specifying Data Types and Query Performance

Performance penalties for omitting SQL data types when using ADO.Net or light weight ORMs.  Read more...
By Chad Feghali 2015/06/22 | Source: SQLServerCentral.com | Category: ado.net
Rating: |  Discuss |   Briefcase | 5,479 reads
<< Newer    Items 21 to 40 of 13868    Older >>