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

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

Estimated Number of Rows to be Read

Rob Farley uses this month's T-SQL Tuesday to show off the results of one of his Connect items : Estimated Number of Rows to be Read.  Read more...
By Additional Articles 2017/02/06 | Source: | Category: rows
Rating: (not yet rated)  Rate this |   Briefcase | 3,295 reads

Close Encounters of the CEIP Kind

Microsoft's Customer Experience Improvement Program for SQL Server: once easy to avoid, now hard to ignore, but Rodney Landrum sees an upside.  Read more...
By Rodney Landrum 2017/02/06 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 35 reads

Performance of the SQL MERGE vs. INSERT/UPDATE

The SQL MERGE statement offers convenience, safety and elegance, but how does it perform compared to other methods?  Read more...
By Dwain Camps 2017/02/03 (first published: 2013/10/28) | Source: | Category: merge
Rating: |  Discuss |   Briefcase | 36,615 reads

Your Favorite Feature that Needs Work

This week Steve Jones asks what parts of SQL Server would you improve and why.  Read more...
By Steve Jones 2017/02/03 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 61 reads

PowerShell Invoke-SQLCmd outputs DataTables you can INSERT into SQL Server

Aaron Nelson explains how you can take an existing SQL query, run it against a SQL Server and then take the results and save them to a different SQL Server without using Linked Servers.  Read more...
By Additional Articles 2017/02/03 | Source: | Category: powershell
Rating:  Rate this |   Briefcase | 3,585 reads

Is your SQL Server remote?

If the answer is yes, this survey is for you. Redgate is looking at building solutions to the issues associated with remote SQL Servers. They want to know your pain points, and whether there's anything they can do to assist. If you think you could help the team out, please fill in their survey.  Read more...
By 2017/02/03 | Source: Redgate | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 4,702 reads

The Great and Powerful Internet of Things

A look at the good, and bad, of the IoT world along with the potential future.  Read more...
By Steve Jones 2017/02/02 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 72 reads

Preferred Node Policy-Setting on Traditional SQL Cluster

Preferred node setting facilitates instances on traditional cluster to be on the correct nodes which will lead to load-balancing of the resources.  Read more...
By SQL ADMIN 79 2017/02/02 | Source: | Category: clustering
Rating: (not yet rated) |  Discuss |   Briefcase | 514 reads

Using A Block Predicate to Restrict Row Updates and Inserts

If you are using row level security in SQL Server 2016 you might find users are updating or inserting rows of data that keep them from seeing the row after they have performed the update or insert statement. If you want to prevent this from occurring, you can use a blocking predicate.  Read more...
By Additional Articles 2017/02/02 | Source: Database Journal
Rating: (not yet rated)  Rate this |   Briefcase | 6,259 reads

Byte Me: Avoiding Detection

By Bob Lang 2017/02/01 | Source: | Category: byte me
Rating: (not yet rated) |  Discuss |   Briefcase | 102 reads

Stairway to Server Management Objects (SMO) Level 3: The Database Class

Learn how to get started working with SMO and PowerShell.  Read more...
By Laerte Junior 2017/02/01 | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 722 reads

Introducing Minion CheckDB by MinionWare

Minion CheckDB completes the MinionWare maintenance and backups suite in style. Each solution is plug-and-play for the busy DBA, and deeply configurable for those shops with in-depth needs.  Read more...
By Press Release 2017/02/01 | Source: | Category: minionware
Rating: (not yet rated) |  Discuss |   Briefcase | 460 reads

Planning for Successful Data Management

It is the data, in particular, that sets Database Lifecycle Management apart from the mainstream of application delivery. Data entities, and the way that organisations understand and deal with them, have their own lifespan. If we neglect the management of data, we risk disaster for the organisations that use it. If we take data management seriously, databases become a lot easier.  Read more...
Rating:  Rate this |   Briefcase | 4,551 reads

A Wide Variation in Skill

We all have different levels of skills, and it's not always because we don't try. Sometimes it's a question of timing.  Read more...
By Steve Jones 2017/01/31 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 115 reads

Loading Non Duplicated Data Using SSIS

Learn how you can easily load data from a file that isn't duplicated, discarding those rows that are.  Read more...
Rating: |  Discuss |   Briefcase | 1,205 reads

SQL Server v.Next : STRING_AGG Performance, Part 2

Aaron Bertrand starts digging deeper into the performance of string concatenation methods STRING_AGG and FOR XML PATH.  Read more...
By Additional Articles 2017/01/31 | Source: | Category: string_ag
Rating:  Rate this |   Briefcase | 2,771 reads

The New DBA is a Developer

Today Steve Jones says the lines between developers and DBAs is blurred.  Read more...
By Steve Jones 2017/01/30 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 179 reads

Azure SQL Data Warehouse with PowerShell

We will teach how to create a new SQL Azure Data Warehouse using Powershell  Read more...
By Daniel Calbimonte 2017/01/30 | Source: | Category: azure
Rating: |  Discuss |   Briefcase | 414 reads

DevOps and Database Lifecycle Management

Database Lifecycle Management (DLM) aims to provide a roadmap of what is required, and when, to deliver and maintain effective databases that can respond quickly to business change. How does the DevOps movement, as it applies to databases, fit into this? William Brewer explains how DevOps provides the organisational change between delivery and operations to make important parts of the process easier to introduce.  Read more...
By Additional Articles 2017/01/30 | Source: SimpleTalk | Category: devops
Rating:  Rate this |   Briefcase | 2,607 reads

The vNext Bleeding Edge

Microsoft has a new early access program for SQL Server.  Read more...
By Steve Jones 2017/01/30 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 54 reads
<< Newer    Items 41 to 60 of 15475    Older >>