Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

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

The Opportunistic Hacker

Sometimes the crimes of opportunity might be the worst ones for our data.  Read more...
By Steve Jones 2015/04/14 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 179 reads

Prevent and Log Certain SQL Server Login Attempts

Aaron Bertrand presents a more elegant to prevent developers from attempting to log into production databases using application logins (and to log any such attempts).   Read more...
By Additional Articles 2015/04/14 | Source: MSSQLTips.com | Category: login
Rating: (not yet rated)  Rate this |   Briefcase | 6,340 reads

SQL Monitor Custom Metric: Tables Without Clustered Indexes

This metric by Fabiano Amorim measures the number of tables without clustered indexes defined that contain more than 1000 rows per database. This is good practice to help improve query performance.  Read more...
By 2015/04/14 | Source: SQL Monitor Metrics | Category: custom metrics
Rating: (not yet rated)  Rate this |   Briefcase | 5,862 reads

Maps in SQL Server Reporting Services

Learn how to add maps to your Reporting Services reports with this article from expert Adam Aspin.  Read more...
By Adam Aspin 2015/04/13 | Source: SQLServerCentral.com | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 6,252 reads

Pre-built or Ad Hoc

Steve Jones talks about the ad hoc nature of some NoSQL databases and whether that's something that most users want.  Read more...
By Steve Jones 2015/04/13 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 111 reads

Don't exaggerate the difficulties of the RDBMS

Phil Factor argues that in learning about relational databases such as SQL Server, we should encourage people to "break a few pots".  Read more...
By Phil Factor 2015/04/13 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 111 reads

Never Ignore a Sort Warning in SQL Server

It is always bad news if your SQL queries are having to use the SORT operator. It is worse news if you get a warning that sort operations are spilling onto TempDB. If you have a busy, slow TempDB, then the effect on performance can be awful. You should check your query plans to try to eliminate SORTs and never leave a SORT warning unheeded. Fabiano Amorim shows the range of ways of getting information on what is going on with a query that is doing a SORT and when requests are made for memory.  Read more...
By Additional Articles 2015/04/13 | Source: SimpleTalk | Category: sort
Rating:  Rate this |   Briefcase | 7,490 reads

Five Rules For Successful Conversations With DBAs

As a developer working with SQL Server, you'll need to work with DBAs at one point or another. Here are some easy ways to make those conversations go smoothly.  Read more...
By Joshua Feierman 2015/04/10 (first published: 2013/09/24) | Source: SQLServerCentral.com | Category: dbas
Rating: |  Discuss |   Briefcase | 17,588 reads

The Internet of Things: A New World Order?

Was the marketing hook 'The Internet of Things' conjured up before the technical definition? Are we being persuaded to spend money on fending off yet another fantasy tsunami of data? Already, we have televisions that listen to, and report, your conversations; so are we facing the Science Fiction future of gadgets that report where you go, who you visit and what medications you take? As Robert Sheldon says; "It's big, almost too big to get your arms around".  Read more...
By Additional Articles 2015/04/10 | Source: SimpleTalk | Category: iot
Rating:  Rate this |   Briefcase | 9,094 reads

After Six Months On The Job What Challenges Remain?

Today we have a guest editorial from Andy Warren that asks what you might do when you get settled at a new job.  Read more...
By Andy Warren 2015/04/10 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 156 reads

Cardinality Estimator – What’s new in SQL Server 2014

SQL Server 2014 has introduced a rebuilt Cardinality Estimator (CE) with new algorithms. Which are the biggest differences between the new CE and the previous one? Which one works better? Read more to find out.  Read more...
Rating: |  Discuss |   Briefcase | 5,373 reads

Creating a multi-option parameter report for SQL Server Reporting Services

If you have a reporting requirement where users want to enter report parameters by either selecting values from a dropdown list or entering To and From range values, Ghanesh Prasad explains how to accomplish this in a Reporting Services report?.  Read more...
By Additional Articles 2015/04/09 | Source: MSSQLTips.com | Category: ssrs
Rating: (not yet rated)  Rate this |   Briefcase | 7,592 reads

State v Migrations

Steve Jones talks a bit about the difference between state based and migrations based approaches for deployment.  Read more...
By Steve Jones 2015/04/09 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 85 reads

Stairway to SQL Server Security Level 7: Security Across Databases with Cross-Database Ownership Chaining

Sometimes you need to reach outside a database and access data and objects from multiple databases, which raises some security issues and increases the complexity of data access. In this stairway level, you’ll learn about cross-database ownership chaining so that you can reach across database boundaries securely.  Read more...
By Don Kiely 2015/04/08 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,004 reads

Release Wednesday

One of the teams at Red Gate is releasing new changes every Wednesday, which reminds Steve Jones of a time earlier in his career.  Read more...
By Steve Jones 2015/04/08 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 66 reads

Free eBook: Performance Tuning with SQL Server Dynamic Management Views

Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA's troubleshooting armory, laying bare previously unavailable information regarding the under-the-covers activity of your database sessions and transactions.  Read more...
By Additional Articles 2015/04/08 (first published: 2013/08/21) | Source: Redgate | Category: performance tuning
Rating:  Rate this |   Briefcase | 58,020 reads

Painless Refactoring of SQL Server Database Objects

Refactoring a database object can often cause unexpected behavior in the code that accesses that object. In this article, adapted from his excellent book, Defensive Database Programming with SQL Server, Alex Kuznetsov discusses several techniques that will harden your code, so that it will not break, or behave unpredictably, as a result such changes.  Read more...
By Additional Articles 2015/04/08 | Source: SimpleTalk | Category: database objects
Rating:  Rate this |   Briefcase | 9,192 reads

What is Database Continuous Integration?

This is an introductory article to explain what Continuous Integration (CI) is and how it can be used in database development.  Read more...
By Steve Jones 2015/04/07 | Source: SQLServerCentral.com | Category: continuous integration
Rating: |  Discuss |   Briefcase | 5,930 reads

Deleting Historical Data from a Large Highly Concurrent SQL Server Database Table

In this tip, Daniel Farina explains an unconventional way of deleting millions of old records from a table which is accessed by a system 24x7, and without impacting that system.  Read more...
By Additional Articles 2015/04/07 | Source: MSSQLTips.com | Category: deleting data
Rating:  Rate this |   Briefcase | 9,623 reads

Kanban

Steve Jones talks about organizing and tracking work with kanban and how that might help you.  Read more...
By Steve Jones 2015/04/07 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 164 reads
<< Newer    Items 41 to 60 of 13677    Older >>