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

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

Performance Surprises and Assumptions : DATEADD()

Aaron Bertrand explores yet another scenario where a date/time function seems to cause the optimizer to behave unexpectedly.  Read more...
By Additional Articles 2016/05/12 | Source: SQLPerformance.com | Category: dateadd
Rating: (not yet rated)  Rate this |   Briefcase | 3,958 reads

Solving Tempdb Issues

A simple change might solve some of those tempdb issues various customers experience.  Read more...
By Steve Jones 2016/05/12 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 125 reads

Use Tools

One of the great things about IT is that we have so many tools to help us do our jobs. We can even build tools as needed. So why don't more IT people take advantage of this?  Read more...
By Steve Jones 2016/05/11 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 435 reads

Stairway to Server Management Objects (SMO) Level 1: Concepts and Basics

Learn how to get started working with SMO and PowerShell.  Read more...
By Laerte Junior 2016/05/11 | Source: SQLServerCentral.com | Category: smo
Rating: |  Discuss |   Briefcase | 2,108 reads

Free eBook: SQL Server Transaction Log Management

When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log, both what it does, and how it works.  Read more...
By Press Release 2016/05/11 (first published: 2013/08/14) | Source: Redgate | Category: transaction log
Rating:  Rate this |   Briefcase | 71,775 reads

Step By Step SQL Server Log Shipping

Jugal Shah walks through the steps of setting up Log Shipping.  Read more...
By Additional Articles 2016/05/11 | Source: MSSQLTips.com | Category: log shipping
Rating: (not yet rated)  Rate this |   Briefcase | 3,766 reads

A Lifetime of Software

Today Steve Jones wants you to look forward in your career. Do you enjoy working with software and technology? Do you plan on doing this for the rest of your career?  Read more...
By Steve Jones 2016/05/10 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 259 reads

Data Mining Part 40: Big Data and Microsoft Data Mining

This article will introduce about big data and HDInsight and Hadoop.  Read more...
By Daniel Calbimonte 2016/05/10 | Source: SQLServerCentral.com | Category: big
Rating: |  Discuss |   Briefcase | 1,010 reads

SQL Server Security Audit Basics

SQL Server Server Audit has grown in functionality over the years but it can be tricky to maintain and use because it lacks centralization and analysis tools. It can do a fast and lightweight audit of many different activities including DML and DDL at both Instance and Database Levels - even the work of the DBAs. How do you check logins and permissions? How do you script an enterprise-wide audit solution? How can you hope to analyse the log data you get? Feodor Georgiev gets you started.  Read more...
By Additional Articles 2016/05/10 | Source: SimpleTalk | Category: security audit
Rating: (not yet rated)  Rate this |   Briefcase | 3,160 reads

Don’t Miss Out on an Opportunity to Connect

There are people in our lives that we want to connect with, so why don't we?  Read more...
By Ben Kubicek 2016/05/09 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 82 reads

RANDom traps for the unwary

The Books Online description of the RAND() function is only true from certain perspectives.  Read more...
By David Poole 2016/05/09 | Source: SQLServerCentral.com | Category: rand()
Rating: |  Discuss |   Briefcase | 1,808 reads

The Information Schema and Cross-RDBMS Working

A look at the ODBC standard and how valuable it has been, unlike the Information Schema implementations.  Read more...
By Phil Factor 2016/05/09 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 48 reads

Announcing BIML Academy

Join Andy Leonard the week of May 9-13 for 5 free days of BIML training.   Read more...
By Press Release 2016/05/09 (first published: 2016/04/26) | Source: SQLServerCentral.com | Category: biml
Rating: (not yet rated)  Rate this |   Briefcase | 7,329 reads

Big Data Architecture

The next few years will be critical for the information technology staff, as they attempt to integrate and manage multiple, diverse hardware and software platforms. In this article, Lockwood Lyon addresses how to meet this need, as users demand greater ability to analyze ever-growing mountains of data, and IT attempts to keep costs down.  Read more...
By Additional Articles 2016/05/09 | Source: Database Journal | Category: big data
Rating: (not yet rated)  Rate this |   Briefcase | 4,944 reads

Unique Indexes Are Code; Non-Unique Indexes Are Data

Unique indexes are the database developer's responsibility. Non-unique indexes can be more easily maintained directly on the production database by an automated process.  Read more...
By Daniel White 2016/05/06 (first published: 2014/06/26) | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 11,817 reads

Work to Live

It's important that you remember to live and enjoy your life as it passes by. Today Steve Jones reminds us that we want to work to live, but also plan to live and plan for the future.  Read more...
By Steve Jones 2016/05/06 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 406 reads

Announcing BIML Academy

Join Andy Leonard the week of May 9-13 for 5 free days of BIML training.   Read more...
By Press Release 2016/05/09 (first published: 2016/04/26) | Source: SQLServerCentral.com | Category: biml
Rating: (not yet rated)  Rate this |   Briefcase | 7,329 reads

SQL Server Reporting Services CountDistinct and Previous Functions

Scott Murray takes a look at what count function variations and related functions are available in SQL Server Reporting Services (SSRS).  Read more...
By Additional Articles 2016/05/06 | Source: MSSQLTips.com | Category: ssrs
Rating:  Rate this |   Briefcase | 2,701 reads

Understanding OPENJSON and FOR JSON in Azure and SQL 2016

An example of exporting and importing table data with JSON in Azure and SQL Server 2016.  Read more...
By Ryan Loftin 2016/05/05 | Source: SQLServerCentral.com | Category: openjson
Rating: |  Discuss |   Briefcase | 1,620 reads

ASP.NET Core: A More Realistic Starter Kit

ASP.NET Core is a fascinating platform with many good ideas, but in its present form (RC1)there is a culture shock for experienced ASP.NET developers to experience the effort involved in porting a realistic application. There is an obvious advantage on being able to host an application on any web server, but is this enough to compensate for losing the convenience of an integrated pipeline?  Read more...
By Additional Articles 2016/05/05 | Source: SimpleTalk | Category: asp.net
Rating: (not yet rated)  Rate this |   Briefcase | 3,178 reads
<< Newer    Items 41 to 60 of 14749    Older >>