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

Questions about T-SQL Expressions You Were Too Shy to Ask

Nobody seems to ask questions about SQL Expressions in forums, even though expressions can cause all sorts of problems. It's time for some straight-forward Q&As, and who better than Robert Sheldon to give the A?  Read more...
By Additional Articles 2014/08/27 | Source: SimpleTalk | Category: expressions
Rating: (not yet rated)  Rate this |   Briefcase | 8,506 reads

SQL Server Service Engine fails to start after applying CU4 for SQL Server 2008 SP1

After performing an update on SQL Server, SQL Server Engine and SQL Agent stop responding.  Read more...
By Hilda E 2014/08/26 | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 2,790 reads

Smooth Database Deployment at SQL in the City 2014

SQL in the City is coming this fall to London and Seattle.  Read more...
By Press Release 2014/08/26 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 32 reads

SQL Saturday #340 - San Diego, CA

SQL Saturday is coming to San Diego on September 20, 2014. This event has a great speaker line-up which includes Itzik Ben-Gan, Grant Fritchey, and many others. Register while space is available.  Read more...
By Press Release 2014/08/26 | Source: SQL Saturday | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 4,623 reads

Big Data Technologists Transition to Customer-Facing Roles

As the enterprise embraces big data, management assumes that staff sizes will decrease. What should be done with those unneeded technologists? One answer: convert them into technology consultants that collaborate and coordinate with the lines of business. In other words, give them customer-facing roles.  Read more...
By Additional Articles 2014/08/26 | Source: Database Journal | Category: big data
Rating: (not yet rated)  Rate this |   Briefcase | 6,278 reads

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,939 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,975 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 | 96 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 | 111 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 | 61 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,201 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,955 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,708 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,640 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,515 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,326 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 | 953 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 | 114 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,864 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 | 102 reads
<< Newer    Items 21 to 40 of 13016    Older >>