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 13862    Older >>
 

#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 | 104 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,743 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,714 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,580 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,699 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 | 368 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,803 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 | 932 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 | 152 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,337 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,067 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,320 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 | 192 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,410 reads

Learning SQL Server 2016

Here is a reference that lets you take a quick look at the new features in SQL Server 2016 and dig into the various items with a collection of links we'll maintain.  Read more...
By Site Owners 2015/06/22 | Source: SQLServerCentral.com | Category: sql server 2016
Rating: |  Discuss |   Briefcase | 3,583 reads

Comparing Oracle and SQL Server Code - Part 1

In this tip, Daniel Calbimonte compares the SQL Server (T-SQL) and Oracle (PL-SQL) extensions of the SQL language. The tip will compare both T-SQL and PL-SQL languages with respect to retrieving data, creating databases, tables, variables, etc.  Read more...
By Additional Articles 2015/06/22 | Source: MSSQLTips.com | Category: oracle
Rating: (not yet rated)  Rate this |   Briefcase | 3,581 reads

The Stress of a Former DBA

Rodney Landrum impresses on his audience the importance of attention to the finer details, during data analysis and reporting.  Read more...
By rodneylandrum 2015/06/22 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 140 reads

Does It Count?

This Friday Steve Jones asks how you track uptime. Does your scheduled maintenance count against your metrics?  Read more...
By Steve Jones 2015/06/19 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 167 reads

Trigger an Email of an SSRS Report from an SSIS Package

This article demonstrates how to trigger an SSRS subscription to email a report from an Execute SQL Task using SQL Server Agent and the ReportServer.dbo.AddEvent stored procedure.  Read more...
By Stan Kulp 2015/06/19 (first published: 2013/03/19) | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 16,969 reads

Script All Server Level Objects to Recreate SQL Server

Carla Abanes provides a guide on how to create a console application that will generate create scripts for server level objects for multiple SQL Server instances. This is handy in the event of a disaster and you need to create a clone of the SQL Server that is no longer available.   Read more...
By Additional Articles 2015/06/19 | Source: MSSQLTips.com | Category: objects
Rating: (not yet rated)  Rate this |   Briefcase | 2,613 reads
<< Newer    Items 21 to 40 of 13862    Older >>