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

<< Newer    Items 61 to 80 of 13858    Older >>
 

Reusing T-SQL Code

Alex Kuznetsov, in an article taken from his book 'Defensive Database Programming with SQL Server', shows how DRY principles can be put in practice with constraints, stored procedures, triggers, UDFs and indexes.  Read more...
By Additional Articles 2015/06/10 | Source: SimpleTalk | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 5,085 reads

SELECT INTO vs INSERT INTO on Columnstore

This article compares SELECT INTO and INSERT INTO under different scenarios, and the best approach preferred.  Read more...
By Ramya Makam 2015/06/09 | Source: SQLServerCentral.com | Category: performance and tuning
Rating: |  Discuss |   Briefcase | 13,251 reads

Archive Every Day

There are challenges with the large scale archiving of data. Steve Jones talks about rethinking this as a daily process rather than a periodic one.  Read more...
By Steve Jones 2015/06/09 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 101 reads

Protecting Yourself from SQL Injection in SQL Server - Part 2

Aaron Bertrand has some advice on how to protect yourself from SQL Injection, looking at some specific common scenarios.   Read more...
By Additional Articles 2015/06/09 | Source: MSSQLTips.com | Category: sql injection
Rating: (not yet rated)  Rate this |   Briefcase | 4,290 reads

SQL Monitor Custom Metric: WriteLog wait time

This metric shows Writelog wait time in ms, per elapsed second. Writelog wait types occur when the log cache is being flushed to disk. If this happens all the time, it may suggest disk bottlenecks where the transaction log is stored.  Read more...
By Press Release 2015/06/09 | Source: SQLServerCentral.com | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 1,915 reads

When Should We Be Cleaning Data?

Part of our job as a data professional often deals with the movement and cleaning of data. However, should we be trying to reduce the work we do? Move the burden to the application? Steve Jones has a few comments.  Read more...
By Steve Jones 2015/06/08 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 159 reads

Query Performance Tuning – A Methodical Approach

Learn how to approach performance tuning in this piece from SQL Server MCM and MVP, Gail Shaw.  Read more...
By Gail Shaw 2015/06/08 | Source: SQLServerCentral.com | Category: performance and tuning
Rating: |  Discuss |   Briefcase | 9,611 reads

How to Get SQL Server Dates and Times Horribly Wrong

One of the times that you need things to go right is when you are doing analysis and reporting. This is generally based on time and date. A sure-fire way of getting managers upset is to get the figures horribly wrong by messing up the way that you handle datetime values in SQL Server. In the interests of peace, harmony and a long career in BI, Robert Sheldon outlines some of the worst mistakes you can make when using SQL Server dates.  Read more...
By Additional Articles 2015/06/08 | Source: SimpleTalk | Category: dates
Rating:  Rate this |   Briefcase | 5,882 reads

The Multi-skilled Developer

Is the DBA a fading star? More likely, there is a general lack of understanding of the roles of the different types of DBA, and of the other IT teams that ensure that successful application developments happen in any large enterprise.  Read more...
By Phil Factor 2015/06/08 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 184 reads

Demystifying the use of CASE in an ORDER BY statement

Chuck Hoffman exposes the mysteries of getting CASE statements to work in dynamic ORDER BY statements.  Read more...
By Chuck Hoffman 2015/06/05 (first published: 2012/04/26) | Source: SQLServerCentral.com | Category: case
Rating: |  Discuss |   Briefcase | 24,881 reads

System Stored Procedures for SQL Azure Linked Servers

Microsoft released the preview version of Azure SQL Database V12 in December of 2014. As a database administrator, you might wonder about the schema and security of these new data marts. Microsoft has supplied system stored procedures for the database developer to query the Linked Servers for this type of meta data, as John Miner explains.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 1,492 reads

Should Salary Information Be Confidential?

Today we have a guest editorial from Andy Warren as Steve is away from the office. Salary is a difficult topic for many, but Andy shares some thoughts.  Read more...
By Andy Warren 2015/06/05 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 234 reads

Data Mining Part 28: Programming with AMO and VB

In this article we will use VB.NET to connect to our Mining Models.  Read more...
By Daniel Calbimonte 2015/06/04 | Source: SQLServerCentral.com | Category: amo
Rating: |  Discuss |   Briefcase | 2,654 reads

The Importance of Database Indexing

In this article, James Munro demonstrates an example of a simple query without an index and then that same query again with the index. A simple introduction to database indexing.  Read more...
By Additional Articles 2015/06/04 | Source: CodeProject.com | Category: indexing
Rating:  Rate this |   Briefcase | 5,779 reads

Architecture for Auditing

The way in which auditing is build into our systems isn't the best way to implement the practice.  Read more...
By Steve Jones 2015/06/04 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 110 reads

Stairway to SQL Server Security Level 9: Transparent Data Encryption

Even an otherwise well-secured database is susceptible to attack if an attacker is able to get access to the disk files that comprise the database. Cell-level encryption can protect some of the data, but for complete protection against this kind of attack it is necessary to encrypt the files and not just the data. That is exactly what Transparent Data Encryption (TDE) does, and in this stairway level you'll learn what TDE does, how it works, and how to make use of it to protect your database files.  Read more...
By Don Kiely 2015/06/03 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,662 reads

What Not To Say

Steve Jones has some advice for data professionals today. These are a few things that your boss doesn't want to hear, and you probably don't want to say.  Read more...
By Steve Jones 2015/06/03 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 662 reads

Free eBook: Fundamentals of SQL Server 2012 Replication

Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book introduces you to the technologies that make up replication, and then walks you through setting up different replication scenarios. When you've finished reading, you should be able to implement your own multi-server replication setup while following the principle of least privilege.  Read more...
By Press Release 2015/06/03 (first published: 2014/02/26) | Source: Redgate | Category: replication
Rating:  Rate this |   Briefcase | 41,150 reads

Query Folding in Power Query to Improve Performance

In this tip Koen Verbeeck discusses query folding, how you can take advantage from it and how to make sure query folding takes place.  Read more...
By Additional Articles 2015/06/03 | Source: MSSQLTips.com | Category: power query
Rating: (not yet rated)  Rate this |   Briefcase | 2,360 reads

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

One of the best ways in which you can build better applications is by learning to write better T-SQL. Mickey Stuewe begins a new series showing how you might start to think about writing queries.  Read more...
By Mickey Stuewe 2015/06/02 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 11,119 reads
<< Newer    Items 61 to 80 of 13858    Older >>