SQLServerCentral: Content tagged Blogs

Indexes – Understanding basic types and their components

The biggest problem developers and newer DBAs have with understanding indexes is that you don’t realize when you’re using the... Read more...

By SteveHood79 2013/05/19 | Source: SQLServerCentral.com | Category: blogs

Rating: (not yet rated) |

Discuss |

Briefcase | 122 reads

Software Design and Schizophrenic Windows 8 Part 2

I know it’s not schizophrenic, but that sounds better. It’s really a split personality. I wrote recently about Windows 8 and... Read more...

By Steve Jones 2013/05/19 | Source: SQLServerCentral.com | Category: blogs

Rating: (not yet rated) |

Discuss |

Briefcase | 121 reads

Windows, RIP (1992 – 2013)

Today is a very sad day for me. My love, my dear Windows has passed away. We were together for... Read more...

By Klaus Aschenbrenner 2013/05/19 | Source: SQLServerCentral.com | Category: blogs

Rating: (not yet rated) |

Discuss |

Briefcase | 120 reads

Certifiable?

I have recently begun to contemplate pursuing the MCSA Certification. I have been working with SQL Server for almost 20... Read more...

By Angela Henry 2013/05/19 | Source: SQLServerCentral.com | Category: blogs

Rating: (not yet rated) |

Discuss |

Briefcase | 109 reads

SQLSaturday #220 Atlanta

From the tweets, it looks like there will be about 800 attendees sitting in on 11 different tracks with 5... Read more...

By Thomas LeBlanc 2013/05/19 | Source: SQLServerCentral.com | Category: blogs

Rating: (not yet rated) |

Discuss |

Briefcase | 94 reads

PowerSQL – Find Size, Name, LastAccess and Last Modified time of all bak files across ALL Servers

We came across a scenario where database bak files being created from long time which are no more in use... Read more...

By Prashanth Jayaram 2013/05/17 | Source: SQLServerCentral.com | Category: blogs

Rating: (not yet rated) |

Discuss |

Briefcase | 722 reads

Indexes – Unused and Duplicates

Indexes aren’t free, and many databases end up with unused indexes. Every time you make any update to a table... Read more...

By SteveHood79 2013/05/19 | Source: SQLServerCentral.com | Category: blogs

Rating: (not yet rated) |

Discuss |

Briefcase | 249 reads

SQLSaturday Redmond(SQLSat212) is almost here…Will you be there?

This is my first SQLSaturday and I’m super excited to attend this event. SQLSaturday’s are always a great opportunity to learn something exciting,... Read more...

By AnupWarrier 2013/05/19 | Source: SQLServerCentral.com | Category: blogs

Rating: (not yet rated) |

Discuss |

Briefcase | 94 reads

Virtualization Networking Tips for SQL Server 2012 AlwaysOn

A while back Kendal Van Dyke (b | l | t) asked me a great question regarding the ideal VMware vSphere networking... Read more...

By kleegeek 2013/05/19 | Source: SQLServerCentral.com | Category: blogs

Rating: (not yet rated) |

Discuss |

Briefcase | 165 reads

Parameterizing an Excel Spreadsheet

I’ve had a few discussions in the past week about not only including Excel spreadsheets on PerformancePoint dashboards, but specifically... Read more...

By 2013/05/19 | Source: SQLServerCentral.com | Category: blogs

Rating: (not yet rated) |

Discuss |

Briefcase | 271 reads

When the person you hire is not the person you hire

This is something I just heard about recently, but then experienced it for myself. This story was told to me: A... Read more...

By 2013/05/19 | Source: SQLServerCentral.com | Category: blogs

Rating: (not yet rated) |

Discuss |

Briefcase | 162 reads

My 2013 SQL Saturday Schedule!

I’ve finally gotten my gear together for (what I consider) the “speaking season”. Here are the SQL Saturdays that I’m... Read more...

By Jen McCown 2013/05/19 | Source: SQLServerCentral.com | Category: blogs

Rating: (not yet rated) |

Discuss |

Briefcase | 109 reads

Bill Gate’s speech

One of my friend shared this content. I’m just sharing with you all.Good one and I like it pretty much!!!!Bill... Read more...

By Prashanth Jayaram 2013/05/19 | Source: SQLServerCentral.com | Category: blogs

Rating: (not yet rated) |

Discuss |

Briefcase | 85 reads

Len() and DataLength()

Both system functions, Len() and DataLength(), in SQL Server are used to measure the length of the data. The main... Read more...

By john_wong_ca 2013/05/19 | Source: SQLServerCentral.com | Category: blogs

Rating: (not yet rated) |

Discuss |

Briefcase | 97 reads

Magnify SQL Text with SSMS 2012

This is just a quick tip to help with folks who present SQL code at events such as SQL Saturday.... Read more...

By Sqlchicken 2013/05/19 | Source: SQLServerCentral.com | Category: blogs

Rating: (not yet rated) |

Discuss |

Briefcase | 101 reads

Rated R (A Teaser)

How many lines of TSQL codes and Window Functions you need to come up with this? With R, it takes about... Read more...

By MarlonRibunal 2013/05/19 | Source: SQLServerCentral.com | Category: blogs

Rating: (not yet rated) |

Discuss |

Briefcase | 130 reads

Lost Phone, Ring,Glasses,Etc, At the Office

If you work at a company with more than a 100 or so employees you probably get an email every... Read more...

By Andy Warren 2013/05/19 | Source: SQLServerCentral.com | Category: blogs

Rating: (not yet rated) |

Discuss |

Briefcase | 116 reads

From Google Reader to Feedly

I shifted to Reader about a year ago mainly for the ability to access my feeds on multiple devices. I’ll... Read more...

By Andy Warren 2013/05/19 | Source: SQLServerCentral.com | Category: blogs

Rating: (not yet rated) |

Discuss |

Briefcase | 144 reads

DMV-11 : T-Log space used by transaction……..sys.dm_tran_database_transactions

sys.dm_tran_database_transactions DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-us/library/ms186957.aspx Returns information about transactions at the database level. Some time , T-log... Read more...

By 2013/05/19 | Source: SQLServerCentral.com | Category: blogs

Rating: (not yet rated) |

Discuss |

Briefcase | 109 reads