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

<< Newer    Items 41 to 60 of 13426    Older >>
 

Dynamically Create Tables Based on an Access Table

Create and Load Sql Server Tables based on Dynamic Access Database  Read more...
By Lee Ann Campbell 2015/01/13 | Source: SQLServerCentral.com | Category: dynamic tables
Rating: |  Discuss |   Briefcase | 4,770 reads

Testing

We know that software testing is important, but we often don't do a great job of executing. Steve Jones talk database testing today.  Read more...
By Steve Jones 2015/01/13 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 93 reads

Exploring Query Plans in SQL

SQL Server keeps the most-used execution plans in cache, so it doesn't need to recompile the same queries every time. How can we benefit from this to find potential performance problems in execution plans?  Read more...
By Additional Articles 2015/01/13 | Source: SimpleTalk | Category: query plans
Rating: (not yet rated)  Rate this |   Briefcase | 8,656 reads

Top 5 things you MUST know about PowerPivot for Excel

Although quite a lot has been written about PowerPivot and its features, there are certain aspects about PowerPivot that may not be obvious, especially to someone who is new to the tool. This articles discusses five such items.  Read more...
By Amir Charania 2015/01/12 | Source: SQLServerCentral.com | Category: powerpivot
Rating: |  Discuss |   Briefcase | 7,469 reads

SQL Prompt Tips #5 - Current Statement Execution

Learn how a new feature in SQL Prompt 6.4 can help you avoid costly mistakes in coding.  Read more...
By Steve Jones 2015/01/12 | Source: SQLServerCentral.com | Category: sql prompt
Rating: |  Discuss |   Briefcase | 1,897 reads

Selling Automation to Ops

Steve Jones thinks that DevOps is the wave of the future for most companies. He has a few ways to try and bridge the gap between development and Operations groups.  Read more...
By Steve Jones 2015/01/12 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 103 reads

Data Lakes

An interesting new paradigm popped up in the news this week: the data lake. It examines data as a model for organizational architectures.  Read more...
By Steve Jones 2015/01/12 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 133 reads

SQL Server PCI DSS Security Patching Checklist

PCI DSS has strict requirements about implementing security updates and using only applications which are supported by the vendors. How do you create a patching policy for SQL Servers?  Read more...
By Additional Articles 2015/01/12 | Source: MSSQLTips.com | Category: security
Rating: (not yet rated)  Rate this |   Briefcase | 4,945 reads

Using EXCEPT to Determine Row Differences

How to use the EXCEPT statement to perform row differences.  Read more...
By M. Douglas Bowan II 2015/01/09 (first published: 2014/03/25) | Source: SQLServerCentral.com | Category: except
Rating: |  Discuss |   Briefcase | 29,044 reads

Multiple Backup Files

This Friday Steve Jones looks at your backup system and wonders how many people use striped backups.  Read more...
By Steve Jones 2015/01/09 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 138 reads

Backing up your SQL Server to Amazon's Cloud in Three Easy Steps

John Grover explains how to set up Amazon S3 storage, install and configure the Amazon PowerShell module, and set up a Maintenance plan using SQL native backups and PowerShell.  Read more...
By Additional Articles 2015/01/09 | Source: MSSQLTips.com | Category: s3
Rating: (not yet rated)  Rate this |   Briefcase | 6,493 reads

Installing tSQLt

Get started testing your database code with the tSQLt framework.  Read more...
By Steve Jones 2015/01/08 | Source: SQLServerCentral.com | Category: tsqlt
Rating: |  Discuss |   Briefcase | 8,687 reads

Two Days Off

Verizon is taking their cloud service offline for maintenance for two days. Steve Jones doesn't think that sounds good.  Read more...
By Steve Jones 2015/01/08 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 164 reads

Archiving Hierarchical, Deleted Transaction Using XML

When you delete a business transaction from the database, there are times when you might want to keep a record of the data for posterity. In this article, Dwain Camps looks at a tidy means of doing just that.  Read more...
By Additional Articles 2015/01/08 | Source: SimpleTalk | Category: xml
Rating: (not yet rated)  Rate this |   Briefcase | 10,763 reads

Stairway to PowerPivot and DAX - Level 8: Function / Iterator Function Pairs: The DAX COUNT() and COUNTX() Functions

As a part of his “Function / Iterator Pairs” mini-series, Business Intelligence architect, Analysis Services Maestro, and author Bill Pearson introduces the DAX COUNT() and COUNTX() functions, discussing similarities and differences. He then provides some hands-on exposure to the use of each, particularly in combination with other DAX functions, in generating counts to meet differing needs within our PowerPivot model designs.  Read more...
By Bill Pearson 2015/01/07 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,811 reads

Test Your Situation

One of the important things is to be able to recover your environment. That doesn't mean you need to know everything about SQL Server and potential disasters, but you should know their affect on your situation.  Read more...
By Steve Jones 2015/01/07 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 98 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/01/07 (first published: 2014/02/26) | Source: Red-Gate | Category: replication
Rating:  Rate this |   Briefcase | 31,023 reads

Importance of Statistics and How It Works in SQL Server – Part 1

SQL Server Query Optimizer uses statistical information to estimate the cardinality in a query result. This enables the SQL Server Query Optimizer to create a high-quality query execution plan. Read on to learn how to use statistics and why it’s needed.  Read more...
By Additional Articles 2015/01/07 | Source: Database Journal | Category: query optimizer
Rating:  Rate this |   Briefcase | 7,000 reads

Scrubbing Personally Identifiable Information

Managing personally identifiable information when moving databases to unsecure environment can be challenging. With this flexible and extendable solution for scrubbing it, you can save yourself some time and effort.  Read more...
By Daniel Brown 2015/01/06 | Source: SQLServerCentral.com | Category: restore
Rating: |  Discuss |   Briefcase | 6,488 reads

Recovering from Bad Deployments

When you deploy software, what do you do if things don't go well? Steve Jones talks about a few options you might have.  Read more...
By Steve Jones 2015/01/06 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 108 reads
<< Newer    Items 41 to 60 of 13426    Older >>