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

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 | 100 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,607 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 | 96 reads

Free eBook: SQL Server Hardware

SQL Server Hardware will provide the fundamental knowledge and resources you need to make intelligent decisions about choice, and optimal installation and configuration, of SQL Server hardware, operating system and the SQL Server RDBMS.  Read more...
By Press Release 2014/08/20 (first published: 2013/07/24) | Source: Red-Gate | Category: hardware
Rating:  Rate this |   Briefcase | 22,685 reads

Quickly Investigating What's in the Tables of SQL Server Databases

From SQL Server Management Studio it's hard to look through the first few rows of a whole lot of tables in a database. This is odd, since it is a great way to get quickly familiar with a database. Phil tidied up a SQL routine he uses to investigate databases quickly in a browser. He explains how to use it, how it works, and how to use it from PowerShell.  Read more...
By Additional Articles 2014/08/20 | Source: SimpleTalk | Category: tables
Rating: (not yet rated)  Rate this |   Briefcase | 7,558 reads

Finding special characters within character strings

Special Characters can lead to many problems. Identifying and reporting on them can save a lot of headache down the road.  Read more...
By Michael Morin 2014/08/19 | Source: SQLServerCentral.com | Category: special characters
Rating: |  Discuss |   Briefcase | 8,196 reads

Artist or Scientist?

In your work, are you an artist or a scientist? Steve Jones knows we need to be both, but when is each appropriate?  Read more...
By Steve Jones 2014/08/19 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 130 reads

SQL Monitor Custom Metric: Out of memory errors

The number of out of memory errors that have occurred within a rolling five minute window. If you just want to keep an eye out for any memory errors, you can watch the ring buffers for the Out of memory errors alert when it gets registered there.  Read more...
By Press Release 2014/08/19 | Source: Red-Gate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 6,050 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,477 reads

How to configure SSL encryption in SQL Server

Tibor Nagy explains how to configure Secure Sockets Layer (SSL) encryption on our SQL Servers, with a trusted certificate.  Read more...
By Additional Articles 2014/08/19 | Source: MSSQLTips.com | Category: ssl
Rating: (not yet rated)  Rate this |   Briefcase | 7,922 reads

Automate Your Central Management Server Registrations

Easily register SQL Servers in your inventory to your CMS for easy multi-server queries.  Read more...
By S. Kusen 2014/08/18 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,016 reads

Common database deployment blockers and Continuous Delivery headaches

Deployability is now a first class concern for databases, so why isn’t it as easy as it should be? Matthew Skelton explores seven of the most common challenges which will bring your database deployments to their knees.  Read more...
By Additional Articles 2014/08/18 | Source: SimpleTalk | Category: database deployment
Rating: (not yet rated)  Rate this |   Briefcase | 7,917 reads

Disconnecting Auditing

Currently we have system administrators responsible for securing our systems, including the auditing capabilities. However that's not the best way to ensure that we can protect our systems.  Read more...
By Steve Jones 2014/08/18 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 68 reads

The Broad View

An ingenuous use of existing data leads to the thought - when are we so deep in our work that we can't see how to improve?  Read more...
By Dave Convery 2014/08/18 | Source: SQLServerCentral.com | Category: open data
Rating: (not yet rated) |  Discuss |   Briefcase | 17 reads

SQL Saturday #300 - Kansas City

SQL Saturday is coming to Kansas on September 13, 2014. Our very own Steve Jones will be presenting, alongside other big names like Glenn Berry, Kathi Kellenberger, Sean and Jen McCown, Jason Strate, and many more. Register while space is available.  Read more...
By Press Release 2014/08/18 | Source: SQL Saturday | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 5,328 reads

The Next Generation

Steve Jones wonders about the next generations of IT workers. Can we encourage more people to enter this field? With the supposed shortages of talent today and the poor reputation of IT positions, can we change the trend of fewer people entering IT?  Read more...
By Steve Jones 2014/08/15 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 135 reads

From Hairdresser to DBA – How to start a career in IT

In writing about his career change from hairdresser to DBA, Greg Lucas shares his experiences and offers advice for those looking to move into IT.  Read more...
By Greg M Lucas 2014/08/15 (first published: 2012/09/11) | Source: SQLServerCentral.com | Category: professional development
Rating: |  Discuss |   Briefcase | 15,981 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 | 923 reads

Why the SQL Server FORCESCAN hint exists

It is often generalized that seeks are better than scans in terms of retrieving data from SQL Server. The index hint FORCESCAN was recently introduced so that you could coerce the optimizer to perform a scan instead of a seek. Which might lead you to wonder: Why would I ever want a scan instead of a seek?  Read more...
By Additional Articles 2014/08/15 | Source: MSSQLTips.com | Category: forcescan
Rating: (not yet rated)  Rate this |   Briefcase | 6,933 reads

SQL Saturday #323 - Paris

On September 13, 2014 the French SQL Server Community (GUSS) will be holding a SQL Saturday conference. The event is free to attend, with 4 paid-for pre-conference sessions available. Register while space is available.  Read more...
By Press Release 2014/08/15 | Source: SQL Saturday | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 5,423 reads
<< Newer    Items 21 to 40 of 12999    Older >>