|
|||||
|
Next 10 days will be pretty busy as I will be presenting my session “Anatomy of a Join” at SQL Saturday #160 in Kalamazoo, MI on Saturday September 22, 2012 and the following week at SQL Saturday #149 in Minneapolis, MN on Saturday September 29, 2012 SQLSaturday is a training event for SQL Server professionals [...] I will be presenting my session on “Optimizing SQL Server I/O with Solid State Drives” at SQL Saturday #119 in Chicago on Saturday May 19, 2012! Since this is the 4th time I’m presenting this and I kept accumulating a lot of ideas related to Solid State Drives I decided to start a series of [...] SQL Server 2012 Release Candidate is now Available from SQL Server Team blog The Data Scientist from BuckWoody 7 Scaling Strategies Facebook Used to Grow to 500 Million Users HighScalabilty 10 Sloppy Social Media Mistakes to Fix NOW from Hubspot Blog What is Hadoop? And Why is it Good for Big Data? from The Data [...] This is the second time I’m writing a post in the “Meme Monday” series and this time it originates from Tom LaRock (blog | twitter). The topic is : What #SQLfamily means to me. This weekend I participated in a #SQLfamily reunion in Washington, DC. Some might argue that this is called SQL Saturday #96 [...] John Sterrett blog|twitter asked a question about “How do I loop by rowcount in SSIS? I have a table with 5 million IDs and would like to loop to process 10K at a time. #sqlhelp” This cannot be done natively in SSIS but you could create a stored procedure that uses the concept known as [...] I am deeply honored that I was chosen to present 2 sessions at SQL Saturday #96 in Washington, DC this Saturday, November 5, 2011! Location is: Microsoft MTC 5404 Wisconsin Ave, Suite 700 Chevy Chase, MD 20815 View Larger Map Subway: Friendship Heights Metro Station SQLSaturday is a training event for SQL Server professionals and those [...] Recently I switched my ISP from AT&T DSL (I know … what was I thinking) back to Comcast. The process went thru very quick and in 30 minutes my old cable modem was hooked up and provisioned and was seeing 23 Mb/s speeds. with 11ms response time. But… wait. As soon as I started using [...] This entry is part 1 of 1 in the series SQL Server vs. Oracle Last week Erin Stellato (blog| twitter) has asked a very interesting question on Twitter that triggered this post: So how is it you can have good perf in Oracle, w/o IOTs, but in SQL Server, everyone says need CIs for good perf? [...] Welcome to the first Meme Monday! This idea was brought to life by Thomas Larock (Blog|Twitter). Here’s mine Real DBAs never use DBCC SHRINKDATABASE.Because they know better! For those of us that com from an Eastern European country, Scorpions is a legend. Their songs have made us strong and gave us the force to go forward like a “Wind of change”. But sadly they have announced that their newest album: “Sting in the Tail” Is also their last. Thank you for keeping [...] Tonight we started the fire in the outdoor fireplace enjoyed the warmth of the fire and in the end I roasted chestnuts in the hot embers. It’s funny how memories are triggered by simple things like a smell or an object. Source: Flickr All of a sudden while roasting the chestnuts my mind wandered [...] I recently saw the worst example of how not to design a table and indexes in SQL Server. So here it is: Table1(UserID,ActivityID,ActivityType,AddDate) Role : Log any activity that a user is invited for. PrimaryKey: … Wait for it … tada : UserID,ActivityID,ActivityType,AddDate … Wait you say …. YES … all table columns are used [...] |
|
||||
|
Copyright © 2013 Positively SQL - All Rights Reserved Powered by WordPress & Atahualpa |
|||||