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

Auto Generating Multiple XML Files Using SSIS

An SSIS package that can generate an XML file for each record in an XML column in a SQL Server Database using the Source Script Component in a Data Flow Task.   Read more...
By C.J. Garcia 2014/08/25 | Source: SQLServerCentral.com | Category: ssis
Rating: |  Discuss |   Briefcase | 2,886 reads

The Mindset of the Enterprise DBA: 8 Ways To Centralize Your Work

As well as standardizing and documenting, the enterprise DBA needs to centralize the management of systems. Joshua Feierman explains.  Read more...
By Additional Articles 2014/08/25 | Source: SimpleTalk | Category: dba skills
Rating: (not yet rated)  Rate this |   Briefcase | 7,731 reads

Testing is Your Best Investment

One of the things that can make a big difference in how well your software performs is testing.  Read more...
By Steve Jones 2014/08/25 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 92 reads

The Flash Database

What is the impact of flash storage on databases? There are quite a few, but this week Steve Jones asks if SQL Server should do more to take advantage of them.  Read more...
By Steve Jones 2014/08/25 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 106 reads

Production Subsets

Working with data in development or test environments can be challenging. This week Steve Jones asks how you might deal with the volume of data and whether you like subsets.  Read more...
By Steve Jones 2014/08/22 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 59 reads

The Best Database Administrators Automate Everything

Do you understand the value of your time? I mean really understand it. Time is your absolute number one most valuable asset. Once it's gone, that's it, gone forever.  Read more...
By John Sansom 2014/08/22 (first published: 2012/04/06) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 17,146 reads

Management of Windows Azure SQL Databases via PowerShell with REST APIs

Management of Azure SQL Databases has been greatly simplified by the introduction of the Azure PowerShell module. Marcin Policht describes the principles of dealing with the Azure PowerShell module’s REST APIs directly.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 6,877 reads

SQL Saturday #310 - Dublin, Ireland

SQL Saturday is coming to Dublin on September 20, 2014. Come for a free day of SQL Server training and networking. This year's conference features a mix of levels, topics, and speakers like Buck Woody (Big Data), Jen Stirrup (PowerBI), Denny Cherry (Storage), Red Gate's Tom Austin (Continuous integration), and more. Register while space is available.  Read more...
By Press Release 2014/08/22 | Source: SQL Saturday | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 7,629 reads

Data Mining: Part 14 Export DMX results with Integration Services

In this chapter we will explain how to work with Data Mining models and the Integration Services. Specifically, we will talk about the Data Mining Query Task in SSIS.  Read more...
By Daniel Calbimonte 2014/08/21 | Source: SQLServerCentral.com | Category: ssis
Rating: |  Discuss |   Briefcase | 1,617 reads

Newsletter Changes - Reducing Size

A change to the newsletter is coming soon.  Read more...
By Site Owners 2014/08/21 (first published: 2014/08/19) | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: |  Discuss |   Briefcase | 1,509 reads

Office 365 Essentials - Subscriptions and Licenses

Should you be planning to move from Exchange to Office 365? If so, why? What sort of license should you get, and should you use cloud identities or federated identities for your users?  Read more...
By Additional Articles 2014/08/21 | Source: SimpleTalk | Category: cloud services
Rating: (not yet rated)  Rate this |   Briefcase | 7,247 reads

Red Gate Rolls Out the Red Carpet for SQL Server Users

SQL in the City, the unique event for database developers and administrators organized by Red Gate Software, hits the streets of London and Seattle this fall. Now in its fourth year, it features presentations by some of the world’s top SQL Server speakers.  Read more...
By Press Release 2014/08/21 (first published: 2014/08/15) | Source: SQL in the City | Category: sql in the city
Rating: (not yet rated) |  Discuss |   Briefcase | 949 reads

Bronze Age Development

The slow pace of Visual Studio development had a number of problems over the years, but Microsoft has dramatically changed the way they build their software for the better.  Read more...
By Steve Jones 2014/08/21 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 108 reads

Stairway to T-SQL DML Level 12: Using the MERGE Statement

The final level of this stairway looks at the MERGE statement in detail, focusing on how to perform insert, update and delete logic using the MERGE statement.  Read more...
By Gregory Larsen 2014/08/20 (first published: 2013/01/16) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 15,811 reads

Yet Another Attack Vector

The lack of progress in amending our laws to handle the digital revolution in our leaves may leave us open to unexpected attacks.  Read more...
By Steve Jones 2014/08/20 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 100 reads

Free eBook: SQL Server Hardware

SQL Server Hardware will provide the fundamental knowledge and resources you need to make intelligent decisions about choice, and optimal installation and configuration, of SQL Server hardware, operating system and the SQL Server RDBMS.  Read more...
By Press Release 2014/08/20 (first published: 2013/07/24) | Source: Red-Gate | Category: hardware
Rating:  Rate this |   Briefcase | 23,380 reads

Quickly Investigating What's in the Tables of SQL Server Databases

From SQL Server Management Studio it's hard to look through the first few rows of a whole lot of tables in a database. This is odd, since it is a great way to get quickly familiar with a database. Phil tidied up a SQL routine he uses to investigate databases quickly in a browser. He explains how to use it, how it works, and how to use it from PowerShell.  Read more...
By Additional Articles 2014/08/20 | Source: SimpleTalk | Category: tables
Rating: (not yet rated)  Rate this |   Briefcase | 8,313 reads

Finding special characters within character strings

Special Characters can lead to many problems. Identifying and reporting on them can save a lot of headache down the road.  Read more...
By Michael Morin 2014/08/19 | Source: SQLServerCentral.com | Category: special characters
Rating: |  Discuss |   Briefcase | 8,473 reads

Artist or Scientist?

In your work, are you an artist or a scientist? Steve Jones knows we need to be both, but when is each appropriate?  Read more...
By Steve Jones 2014/08/19 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 135 reads

SQL Monitor Custom Metric: Out of memory errors

The number of out of memory errors that have occurred within a rolling five minute window. If you just want to keep an eye out for any memory errors, you can watch the ring buffers for the Out of memory errors alert when it gets registered there.  Read more...
By Press Release 2014/08/19 | Source: Red-Gate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 6,771 reads
<< Newer    Items 21 to 40 of 13011    Older >>