THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » connect   (RSS)
Showing page 1 of 8 (75 total posts)
  • T-SQL Tuesday #86 My all-time favorite personal SQL Server Enhancement Request: Automatically maintained columns

    I have heard the name T-SQL Tuesday for (like,) ever; but I have always been so into my own bundle of insanity that never took the time to figure out what it is. This changes today because I read a blog on Adam Machanic's (@adammachanic) blog that outlined the rules (here) and I have been keen to get back to blogging regularly. When I saw what ...
    Posted to Louis Davidson (Weblog) by drsql on January 10, 2017
  • The SQL Genie (T-SQL Tuesday #086)

    At some point a long time ago, when I was first getting serious about SQL Server, I became aware of an open secret. You see, there was this special Microsoft alias called “sqlwish.” Those in the know could send an e-mail and pass along suggestions for improving the product. And they wouldn’t just vanish into thin air; some actual member of the ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on January 10, 2017
  • Temporal Tables: Connect Item Round Up

    I've been thinking a lot about SQL Server 2016 temporal tables of late. I think it's possibly the most compelling feature in the release, with broad applications across a number of different use cases. However, just like any v.1 feature, it's not without its faults. I created a couple of new Connect items and decided to see what other ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on October 4, 2016
  • INSERT SELECT is Broken. Ask Microsoft to Fix It.

    Imagine that you're moving thousands or millions of rows between two tables. Maybe it's between a staging table and a data warehouse in an ETL process. Maybe you're manipulating some data via a temp table as you're preparing lookup data for your OLTP system. Maybe you're preparing data for an end user. It doesn't really matter what your use case, ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on May 15, 2013
  • Connect Digest : 2012-07-06

    I've filed a few Connect items recently that I think are important. In #752210, I complain that the documentation for DDL triggers suggests that they can prevent certain DDL from being run, which is not the case at all.      ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on July 6, 2012
  • Connect Digest : 2012-01-09

    Hide databases from users who shouldn't be able to see them This is a long-standing request from Erland Sommarskog which I've highlighted in previous digests. But the underlying problem keeps coming up in multiple venues, so I thought it would be good to call attention to the item one more time. Some will argue that the contained database feature ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on January 9, 2012
  • Connect Digest : 2011-12-20

    Make SSMS start faster A couple of years ago, I blogged about some ways to make Management Studio start faster. With the latest builds of SQL Server 2012, it seems to be slower than ever, at least when starting SSMS for the first time after a reboot or install. So I've asked for them to do something in the background on Windows start-up ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on December 20, 2011
  • Want your bug fixed? File a good bug!

    In some circles I'm known as ''the Connect guy'' because I've filed a heck of a lot of suggestions and bugs that I've envisioned or encountered, and I'm often willing to file an issue on someone else's behalf. In other circles, for very much the same reasons, I'm probably known as ''that annoying Connect guy.'' On and off over the past few years, ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on September 20, 2011
  • Connect Digest : 2011-06-27

    Sorry I have fallen off the Connect Digest wagon for the past few weeks; been a little swamped since returning from SQLCruise Alaska. Not sure I'll be able to assemble a digest every week, but I'll certainly try to keep a steady pace. This week I wanted to highlight a few suggestions around indexed views. With the coming of SQL Server code-named ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on June 27, 2011
  • Connect Digest : 2011-05-23

    Next week I'll be up in Alaska for SQL Cruise, so I'll be skipping at least one digest. This week I gathered a few engine-related issues, two involving what the engine does while an index is being created. The most important one, though, at least IMHO, is the first one listed, involving a hashing algorithm fix that is in SQL Server 2008 R2 - but ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on May 23, 2011
1 2 3 4 5 Next > ... Last »
Privacy Statement