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 [...]
I’ve been meaning to write my blog post on last week’s SQL Saturday experience so finally I got to work so here it is:
After the previous weekend marked a record with 5 (five) SQL Saturday events all around the world on Apr 14 it was time for Wisconsin to show what [...]
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 [...]
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 [...]
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?
Today Mladen Prajdic posted a on Twitter a SQL statement that captured my attention: (http://twitter.com/MladenPrajdic/status/9878219727)
SELECT CONVERT(varchar(50), N’æøåáäĺćçčéđńőöřůýţžš’) COLLATE Cyrillic_General_CI_AI returns aoaaalcccednooruytzs
If you notice the conversion to Cyrillic_General_CI_AI collation his shows an interesting mechanism for code page translation that we could not explain:
Why does Cyrillic_General_CI_AI or Greek_CI_AI collation successfully convert accents to their base ascii [...]
After attending a presentation on SQL Azure by Microsoft’s George Huey an interesting topic came to my mind in regards to the actual use for a cloud based database that has over 1400 incompatibilities with SQL Server: What’s the use for this since it is not a viable alternative to a production database. I would [...]
I’m heading home from the August session of Chicago PASS and SSUG meeting. First off, this was the biggest meeting in Chicago. Over 80 people signed up and for a very good reason. After a very interesting Microsoft SQL Server 2008 Administration with Windows PowerShell presentation by The MAK and Yan Pan, Allan Hirt managed [...]
Eduard gives us the following problem:
The result is that every 4 years for a day you realized the money spent on a Zune are wasted
Now for the Microsoft solution (Please refrain from ROTFL ! ):
Follow these steps:
Disconnect your Zune from USB and AC power sources. Because the player [...]