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

<< Newer    Items 21 to 40 of 14455    Older >>
 

Simplify SQL Server ETL Processes with T-SQL Stored Procedures

Jeremy Kadlec introduces the Enhanced Data Integration Suite (EDIS), a SQL Server T-SQL stored procedure based solution to automate, manage, and audit ETL processes so you no longer have to manually build SSIS Packages.   Read more...
By Additional Articles 2016/02/03 | Source: MSSQLTips.com | Category: etl
Rating:  Rate this |   Briefcase | 4,079 reads

Queues in Databases

The idea of using a queue in a database is one that some people try to avoid, preferring to use a messaging service. However, Steve Jones notes that this isn't always necessary.  Read more...
By Steve Jones 2016/02/03 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 120 reads

Maybe Security is Harder than Rocket Science

It's hard to build strong security over time, but it's worth the effort. Steve Jones notes that even smart people have problems implementing strong security.  Read more...
By Steve Jones 2016/02/02 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 92 reads

SQL Server System Audit Report

Ensuring that your SQL Server is secure is the job of every Database Administrator. In this article I will provide a script to help perform easier audits of your system.  Read more...
By Rudy Panigas 2016/02/02 | Source: SQLServerCentral.com | Category: audit
Rating: |  Discuss |   Briefcase | 2,820 reads

Data security, SQL Server 2016, and Your Business

From an IT infrastructure and compliance perspective, the importance of protecting data is clear. But it also has profound business implications and can even be a competitive differentiator by helping drive customer loyalty and retention. David Hobbs-Mallyon talks about Microsoft’s approach to data security.  Read more...
By Additional Articles 2016/02/02 | Source: TechNet Blogs | Category: sql server 2016
Rating: (not yet rated)  Rate this |   Briefcase | 2,406 reads

What is the True Version of Code?

What version of your code is the true one? Steve Jones talks some version control today.  Read more...
By Steve Jones 2016/02/01 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 94 reads

Find and Remove Duplicate Records SQL Server

Learn a quick method to find and remove duplicate records in your SQL Server tables.  Read more...
By Ginger Keys 2016/02/01 | Source: SQLServerCentral.com | Category: data integrity
Rating: |  Discuss |   Briefcase | 5,768 reads

The PoSh DBA - Towards the Re-usable PowerShell Script

When starting out with PowerShell, it is hard to escape from the detail to work out the best strategy for creating scripts. Laerte Junior explains how, when and why it pays to think in terms of versatile functions to meet varying demands.  Read more...
By Additional Articles 2016/02/01 | Source: SimpleTalk | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 2,355 reads

Bogging Down in the Minutia of Minutes

Rodney Landrum gets lost in the fourth dimension, while coding the infinite possible combinations of SQL Server dates and times.  Read more...
By Rodney Landrum 2016/02/01 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 54 reads

Too much information can be counter-productive

If you want to be an effective communicator focus on what your audience need to hear rather than what you want to say  Read more...
By David Poole 2016/01/29 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 137 reads

Using the Statistical Program R for Running Statistics

This article talks about using the statistical program, R, for applying simple statistics against data in Microsoft SQL Server.  Read more...
By Tomaz Kastrun 2016/01/29 (first published: 2014/03/10) | Source: SQLServerCentral.com | Category: r language
Rating: |  Discuss |   Briefcase | 11,638 reads

The SQL Server 2016 Query Store: Built-in Reporting

One of the most important features of the SQL Server 2016's new Query Store is the reporting. With these features, it is now possible to get a wealth of information on how your query workload is performing, either aggregated for the entire query workload or for a single query. With this information, you can see the effects of 'forcing' an execution plan for specific queries and get feedback of the consequences.  Read more...
By Additional Articles 2016/01/29 | Source: SimpleTalk | Category: query store
Rating: (not yet rated)  Rate this |   Briefcase | 3,322 reads

Manipulating Filetable Files Programatically

Learn how you can work with FileTable files from T-SQL as an alternative to the drag and drop methods of using Windows Explorer  Read more...
By Steve Jones 2016/01/28 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,014 reads

A Review of rsNeatPublish

rsNeatPublish: Toolset to automate deployment of all SSRS 2008R2/12/14/16 objects  Read more...
Rating: (not yet rated) |  Discuss |   Briefcase | 520 reads

Training at the Top

Today Steve Jones looks at security training and the need for understanding from upper management.  Read more...
By Steve Jones 2016/01/28 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 83 reads

Using PowerShell for SQL Server Replication Tracking

Tim Smith shows how using PowerShell can be an effective way to track SQL Server snapshot and transactional replication counts for sources and destinations.  Read more...
By Additional Articles 2016/01/28 | Source: MSSQLTips.com | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 2,224 reads

Byte Me: Making Enemies

By Bob Lang 2016/01/27 | Category: byte me
Rating: (not yet rated) |  Discuss |   Briefcase | 121 reads

Configuring R Services in SQL Server 2016

R Services provides in-database analytics in SQL Server 2016. In this article we step through configuring R Services and get you started with in-database analytics.  Read more...
By Nick Burns 2016/01/27 | Source: SQLServerCentral.com | Category: revolutionr
Rating: |  Discuss |   Briefcase | 3,117 reads

Automate Alerting for SQL Server Suspect Database Pages

We suspect there are some issues with our disk subsystem and would like to be alerted by email if SQL Server encounters any corruption in any of the data files that reside on the disk in question. How can we add this automated monitoring?  Read more...
By Additional Articles 2016/01/27 | Source: MSSQLTips.com
Rating: (not yet rated)  Rate this |   Briefcase | 1,903 reads

DeveloperBall

Steve Jones looks at the challenges of putting a team together of wildly different skill levels.  Read more...
By Steve Jones 2016/01/26 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 99 reads
<< Newer    Items 21 to 40 of 14455    Older >>