Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

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

The DBA Tax

Are you a DBA tax on your company? Or an asset that's worth the cost. Steve Jones talks about trying to be the latter and not the former.  Read more...
By Steve Jones 2016/01/19 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 438 reads

The Real World: Implementing Data Compression in SQL Server 2008 R2

Sharing our experience using Data Compression as a space savings option in MS SQL Server 2008  Read more...
By Kenneth Igiri 2016/01/18 | Source: SQLServerCentral.com | Category: compression
Rating: |  Discuss |   Briefcase | 2,716 reads

Muting the Immutable

Phil Factor on dealing with "immutable" domain data during database development and deployment.  Read more...
By Phil Factor 2016/01/18 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 73 reads

Turn Out the Lights

Today we have a guest editorial from Andy Warren that looks at the costs associated with our behavior.  Read more...
By Andy Warren 2016/01/18 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 126 reads

Documenting Your PowerShell Binary Cmdlets

Whereas it is easy to provide inline documentation for a normal scripted PowerShell cmdlet or function so as to provide comprehensive help at the command-line or IDE, the same isn't true of binary cmdlets written in C#. At last, there is an open-source utility to assist with this that is being actively maintained and updated. At last, binary cmdlets need no longer be the poor cousins of scripted cmdlets in their documentation  Read more...
By Additional Articles 2016/01/18 | Source: SimpleTalk | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 2,740 reads

Having fun with PARSENAME (SQL Spackle)

PARSENAME is perhaps the most infrequently used built-in documented function in SQL Server. SQL Server Microsoft Certified Master Wayne Sheffield shows why this nifty function ought to be included in your SQL toolbox.  Read more...
By Wayne Sheffield 2016/01/15 (first published: 2014/03/17) | Source: SQLServerCentral.com | Category: parsename
Rating: |  Discuss |   Briefcase | 17,935 reads

Wherever I Lay My Hat: Release Management in TeamCity with Redgate DLM

Where you have multiple services, applications and databases in your environment, and perhaps with high levels of scrutiny and governance, you'll probably want a Release Management system for deploying database and application code together: You can, alternatively, use a separate Release Management component. But for simpler applications, you can use your existing build system such as TeamCity to deploy changes. Using a database deployment example, Richard Macaskill shows how.  Read more...
By Additional Articles 2016/01/15 | Source: SimpleTalk | Category: release management
Rating: (not yet rated)  Rate this |   Briefcase | 2,942 reads

Security Convenience

Security is always a hot topic, and Steve Jones notes that we should be specific when we work with security.  Read more...
By Steve Jones 2016/01/15 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 111 reads

I thought my database was collation agnostic

My struggles with a customer's database that used a different collation sequence. The easy way is never the right way, or is it?  Read more...
By Thomas Romeo 2016/01/14 | Source: SQLServerCentral.com | Category: sql collation
Rating: |  Discuss |   Briefcase | 3,391 reads

SQL Server 2016 : Availability Group Enhancements

Aaron Bertrand reveals details about the changes to Availability Groups that will ship in the next major version: SQL Server 2016.  Read more...
By Additional Articles 2016/01/14 | Source: SQLPerformance.com | Category: availability groups
Rating: (not yet rated)  Rate this |   Briefcase | 5,811 reads

Tracking Professional Athletes

Today Steve Jones looks at the use of tracking sensors to gather spatial data on professional athletes for later analysis.  Read more...
By Steve Jones 2016/01/14 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 85 reads

Stairway to SQL Server Extended Events Level 2: Creating Basic Event Sessions in the UI

In this Level, we'll walk through the basics of using the New Session dialog in the UI to create a new event session, define its events, actions and predicates, and establish a target for the session in which to collect the event data.  Read more...
By Erin Stellato 2016/01/13 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,460 reads

The Ongoing Costs of Building Software

There are lots of costs to building your own software, which Steve Jones notes might not be what you want to spend over time.  Read more...
By Steve Jones 2016/01/13 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 130 reads

Comparison of SQL Server Serializable and Snapshot isolation levels

Both Serializable and Snapshot isolation levels exclude concurrency issues such as Dirty Reads, Non-repeatable Reads and Phantoms. However the way in which they deal with such issues is quite different. In this article, Sergey Gigoyan explains the main differences between the two.  Read more...
By Additional Articles 2016/01/13 | Source: MSSQLTips.com | Category: isolation levels
Rating:  Rate this |   Briefcase | 3,038 reads

SQL Family Feud Survey - Technical questions

The first 100 people get to decide the data set. Give us the first thing you think of.  Read more...
By Press Release 2016/01/13 | Source: SQLServerCentral.com | Category: sql family feud
Rating: (not yet rated)  Rate this |   Briefcase | 12,272 reads

Error: Microsoft .NET framework 3.5 service pack 1 is Required

How can you fix a .NET Framework 3.5 error while installing SQL Server 2014?  Read more...
By Ganapathi varma 2016/01/12 | Source: SQLServerCentral.com | Category: sql installation
Rating: |  Discuss |   Briefcase | 3,994 reads

Declarative SQL: Using References

There are several ingenious ways of using SQL References to enforce integrity declaratively. Declarative Referential Integrity (DRI) is more effective than using procedural code in triggers, procedures or application layers because it uses the SQL paradigm, thereby making optimisation easier and providing clearer expression of the rules underlying the data. Joe Celko explains.  Read more...
Rating:  Rate this |   Briefcase | 5,951 reads

The Advent of Code

Today Steve Jones challenges you to solve some programming problems.  Read more...
By Steve Jones 2016/01/12 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 136 reads

When a Service Pack or Cumulative Update Install Fails by “Evaporating"

Learn a few possible solutions to a frustrating issue when you attempt to patch a SQL Server installation.  Read more...
By Mike Hinds 2016/01/11 | Source: SQLServerCentral.com | Category: service packs
Rating: |  Discuss |   Briefcase | 2,612 reads

Top 10 MySQL Reporting Tools

Both management and various departments rely on data reports to help guide their business decisions. Rob Gravelle presents ten open source and commercial report generation tools for MySQL and other relational databases.  Read more...
By Additional Articles 2016/01/11 | Source: Database Journal | Category: mysql
Rating: (not yet rated)  Rate this |   Briefcase | 4,219 reads
<< Newer    Items 61 to 80 of 14459    Older >>