sqlskills.com
Thinking about Hekaton? Then think about collations. - Bob Beauchemin
http://www.sqlskills.com/blogs/bobb/thinking-about-hekaton-then-think-about-collations
You are here: Home. Then think about collations. Then think about collations. Posted on: June 24, 2013 1:19 pm. 8221; whitepaper: “in general, one of the most effective ways to alienate end users of an application is to get a task such as basic sorting wrong.”. Maybe I’m worrying too much about this, as many/most folks in places other than US may be used to using the COLLATE clause on expressions *everywhere*, includng string literals. As Qingsong Yao writes. 3 Got Collation conflict, How to avoid this?
dbaduck.com
dbaduck, Author at Ben Miller (@DBAduck)
http://dbaduck.com/author/dbaduck
SQL Saturday Redmond - April 2, 2016. Be Friendly to SQL - Best Practices. SQL Saturday Madison - April 9, 2016. With PreCon on PowerShell for the DBA. SQL Intersection conference - April 18-21, 2016 in Florida. 2 Sessions and 1 Workshop. Join me at SQL Intersections for a great lineup this year! FreeCon in Seattle, October 27th before PASS Summit 2015. SQL Server TDE on Mirror and Log Shipping. Sysdm db index physical stats Easter Egg. Utah Code Camp 2015 Presentations. January 28, 2016. Bull; 2 Comments.
sqlskills.com
CHECKDB From Every Angle: How to tell if data purity checks will be run? - Paul S. Randal
http://www.sqlskills.com/BLOGS/PAUL/post/CHECKDB-From-Every-Angle-How-to-tell-if-data-purity-checks-will-be-run.aspx
Paul S. Randal. You are here: Home. CHECKDB From Every Angle. CHECKDB From Every Angle: How to tell if data purity checks will be run? CHECKDB From Every Angle: How to tell if data purity checks will be run? Posted on: August 19, 2009 11:04 am. Here’s a question that came up recently:. If I’ve upgraded a database from SQL 2000 or before, how can I tell if the data purity checks will be run or not? As you may know, DBCC CHECKDB. But not by default for upgraded databases. Because the possibility existe...
sqlskills.com
Paul S. Randal - In Recovery...
http://www.sqlskills.com/blogs/paul
Paul S. Randal. New course: Improving Storage Subsystem Performance. Posted on: August 17, 2016 1:37 pm. Glenn’s latest Pluralsight course has been published. SQL Server: Improving Storage Subsystem Performance. And is just over two hours long. It’s based on Glenn’s very popular user group/conference sessions and workshops, plus extensive work with SQLskills consulting clients and in his previous roles. Measuring and Analyzing Storage Subsystem Performance. Testing and Benchmarking Storage Subsystems.
sqlskills.com
Big changes to the MCM program and how SQLskills can help you - Paul S. Randal
http://www.sqlskills.com/BLOGS/PAUL/post/Big-changes-to-the-MCM-program-and-how-SQLskills-can-help-you.aspx
Paul S. Randal. You are here: Home. Big changes to the MCM program and how SQLskills can help you. Big changes to the MCM program and how SQLskills can help you. Posted on: November 9, 2010 8:59 am. This morning at PASS our good friend Joseph Sack, who runs the SQL Server Microsoft Certified Master (MCM) program, announced some sweeping changes to the SQL MCM program and how it look going forward. We at SQLskills. Borrowing a few paragraphs from Brents. The Original Microsoft Certified Master Program:.
sqlskills.com
SQL Server Training and Immersion Events | SQLskills.com
https://www.sqlskills.com/sql-server-training
IE0: Immersion Event for the Accidental/Junior DBA. Just like this grouper is hiding inside a giant barrel sponge, as a new DBA you might be feeling scared of your new responsibilities around SQL Server. There's a lot to learn, but where do you start? What's important and what's not? This course will help you learn how to keep the lights on so that SQL Server meets the business requirements for availability and performance. IEPTO1: Performance Tuning and Optimization – Part 1. There are many things to ev...
zebra-man.blogspot.com
Blends With Savanna Grasses: SQLintersection
http://zebra-man.blogspot.com/2013/03/sqlintersection.html
Blends With Savanna Grasses. The blogspot for all of those superheros and superheroines whose powers weren't quite enough to make it onto the pages of Marvel or DC. Tuesday, March 26, 2013. The best emotion to describe how I'm feeling is 'astounded'. I'm astounded that I'm in such august company to be speaking the SQLIntersection. Conference. Read the blog post from my first SQL Server mentor, Kimberly Tripp, which tells you all about SQLintersection. Check out this list of speakers:. Here On top of the ...
sqlskills.com
SQL Server 2008: New (undocumented) physical row locator function - Paul S. Randal
http://www.sqlskills.com/blogs/paul/sql-server-2008-new-undocumented-physical-row-locator-function
Paul S. Randal. You are here: Home. Inside the Storage Engine. SQL Server 2008: New (undocumented) physical row locator function. SQL Server 2008: New (undocumented) physical row locator function. Posted on: March 20, 2008 12:25 am. One of the drawbacks of not being in the SQL team at Microsoft any longer is that I don’t know about all the undocumented features in the next release – I have to hunt around for them like everyone else :-(. That I’d never heard of. Doing an sp helptext. File id] int not null,.
SOCIAL ENGAGEMENT