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

   Items 1 to 20 of 13263    Older >>
 

Dynamic PIVOT CLR

Learn how yo can use a SQL-CLR procedure to handle all your PIVOT queries.  Read more...
By Eric Wahner 2014/11/28 (first published: 2012/12/06) | Source: SQLServerCentral.com | Category: .net
Rating: |  Discuss |   Briefcase | 12,089 reads

Guidelines for Using Natively-Compiled Stored Procedures in SSIS Packages

As you may know, SQL Server In-Memory OLTP introduced in SQL Server 2014 offers great performance improvements for ETL processes. In this tip we cover techniques you need to know about various behaviors of SQL Server In-Memory OLTP depending on the options you select.  Read more...
By Additional Articles 2014/11/28 | Source: MSSQLTips.com | Category: in-memory oltp
Rating: (not yet rated)  Rate this |   Briefcase | 3,144 reads

Personal Development

Steve Jones thinks that a personal development plan is important and talks today a little about how you should build one.  Read more...
By Steve Jones 2014/11/28 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 637 reads

Templates and teamwork

SQL Server expert David Poole discusses how teams can work together and share templates in Management Studio.  Read more...
By David Poole 2014/11/27 (first published: 2008/05/20) | Source: SQLServerCentral.com | Category: system development life cycle
Rating: |  Discuss |   Briefcase | 9,121 reads

Minimal Meetings

Too many meetings happen in software teams. Steve Jones says that when scheduling meeting, you should be aware of the cost, and only include those people that need to be there.  Read more...
By Steve Jones 2014/11/27 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 158 reads

Explaining The SQL Server 2014 Analysis Services Data Mining Model Lift Chart

In this tip, Dallas Snider explains how to interpret the Lift Chart found on the Mining Accuracy tab of a SQL Server 2014 Analysis Services Data Mining structure.  Read more...
By Additional Articles 2014/11/27 | Source: MSSQLTips.com | Category: data mining
Rating: (not yet rated)  Rate this |   Briefcase | 3,664 reads

Byte Me: Denormalized

A case of SQL infection.  Read more...
By Bob Lang 2014/11/26 | Source: SQLServerCentral.com | Category: byte me
Rating: |  Discuss |   Briefcase | 241 reads

Stairway to SQL Server Indexes: Level 2, Deeper into Nonclustered Indexes

By this stage, you should be familiar with the basics of SQL Server indexes. We've discussed what an Index actually is, as well as some of the most common types you're likely to encounter. Now that we've seen some simple examples of how Indexes can be useful, we're going to delve deeper into nonclustered indexes, as we'll see how they can improve the performance of more complex queries.  Read more...
By David Durant 2014/11/26 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 21,009 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 2014/11/26 (first published: 2013/08/21) | Source: Red-Gate | Category: performance tuning
Rating:  Rate this |   Briefcase | 40,733 reads

SSIS 2012 Projects: Deployment Configurations and Monitoring

The Project Deployment Model introduced in SSIS 2012 speeds up the deployment of database projects in which there may be hundreds of SSIS packages per project. Not only that, but deployments can be configured differently for each environments such as test and staging, and there are now ways of monitoring the status and performance of packages and of versioning the SSIS Catalog.  Read more...
By Additional Articles 2014/11/26 | Source: SimpleTalk | Category: ssis
Rating: (not yet rated)  Rate this |   Briefcase | 3,903 reads

Using SQL Server Stored Procedures in SSIS Data Flow Sources

A technique to deal with lack of metadata for stored procedures when used with SSIS.  Read more...
By Adán Bucio 2014/11/25 | Source: SQLServerCentral.com | Category: data flow task (ssis)
Rating: |  Discuss |   Briefcase | 3,465 reads

Building an Automated Database Deployment Pipeline

Data and databases are historically ignored or given a low priority within the processes of ALM and DevOps. This situation needs to change and the primary point of the changes is within the database professional part of the team.  Read more...
By Additional Articles 2014/11/25 | Source: SQL Server Magazine | Category: database deployment
Rating:  Rate this |   Briefcase | 5,013 reads

Consolidating Again and Again and Again

This editorial was originally published on November 12, 2009. It is being re-run as Steve is on holiday. Virtualization is touted as a great way to save money, but it's a one time event. Once you've consolidated a server, you can't do it again. However consolidation isn't necessarily the same and Steve Jones tells us why.  Read more...
By Steve Jones 2014/11/25 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 196 reads

Data Mining Part 22: Analyze the Data Mining Data with Excel

This is the last article related to Data Mining in Excel. This last chapter will cover the Analyze section.  Read more...
By Daniel Calbimonte 2014/11/24 | Source: SQLServerCentral.com | Category: data
Rating: (not yet rated) |  Discuss |   Briefcase | 1,827 reads

The Salesforce Platform: The Return of the Citizen Programmer

The current popularity of the Salesforce software development platform has taken the industry by surprise. The current IT culture favours the esoteric, yet here is a development platform geared to the idea that anyone can use it: a populist language like BASIC. Does this threaten the careers of professional developers?  Read more...
By Additional Articles 2014/11/24 | Source: SimpleTalk | Category: salesforce
Rating: (not yet rated)  Rate this |   Briefcase | 7,234 reads

How Often Does Production Drift?

Database drift is the difference between two database schemas. Today Steve Jones discusses the concept and wonders how often it happens.  Read more...
By Steve Jones 2014/11/24 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 89 reads

What Counts for a DBA: Empathy

Louis Davidson on how he learned to empathize with his managers.  Read more...
By Louis Davidson (@drsql) 2014/11/24 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 97 reads

Generate SSRS reports from a SSIS Package

Learn how to invoke SSRS reports from an SSIS package after the data load is completed.  Read more...
By Ravindra Chhabria 2014/11/21 (first published: 2012/10/09) | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 15,480 reads

Real World T-SQL Tricks

This week Steve Jones wonders if you're taking advantage of the changes in the T-SQL language.  Read more...
By Steve Jones 2014/11/21 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 383 reads

Questions About Using TSQL to Import Excel Data You Were Too Shy to Ask

It is easy to import Excel data into database tables via TSQL, using OLEDB, either by the OPENROWSET function or linking to the spreadsheet as a server. The problem is that there are certain things that aren't obvious that you need to know about.  Read more...
By Additional Articles 2014/11/21 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 7,610 reads
   Items 1 to 20 of 13263    Older >>