Latest Blog Posts
I was getting lot of responses on blogs and mails. It will be difficult to cover all at once . So covering today the latest one “How to Configure Search in SharePoint 2013” and in Standalone server.
Microsoft is focusing more and more on Power Shell and this…
Next week I will be in Seattle for the 2014 SQL Pass Summit event. If you are involved in projects that leverage the Microsoft SQL Server stack this is a great conference to attend. If this is your first time going and would like some tips on making the most… Read more
SQL Server has two types of execution plan iterators: Blocking and Non-Blocking.
A non-blocking iterator gets rows in and sends rows out at the same time. For instance, the Nested Loops iterator gets rows from its outer input and sends the matching rows on to the next iterator without having… Read more
I was working on a demo recently and needed to show that a little monitoring can help you catch schema changes. At first I looked at SQL Audit and DDL Triggers, but then I ran across a short custom metric on the SQL Monitor Metrics site that my company, Red… Read more
SQLSaturday Tampa is the first SQLSaturday in Florida for 2015, scheduled for February 28th, 2015. The event is held at the USF College of Business Bldg, 12212 USF Maple Drive, Tampa, FL 33620. Easy to find, free parking, lots of hotel options near by. The weather at the end of… Read more
I can hardly believe how fast this year has flown by. My favorite SQL Server conference of the year, the PASS Summit, is just next week! I can hardly wait! This conference is one of the largest SQL Server and BI conferences of the year, planned and coordinated by… Read more
Well, it is that time of year again. The Professional Associations for SQL Server (PASS) annual summit. This year we go back to Seattle where Microsoft mostly lives and hope we can get lots of their employees to visit and talk shop.
One of my main goals is to Network… Read more
Over the years Andy has blogged about his experiences with managing technical teams. Andy wrote over 50 post on the subject and has… Read more
In early October my third book was published. I have been blessed to be able to work with Joes2Pros for my first two books, however Joes2Pros is focusing its time and energy into video content. When SQL 2014 was released and new features were added for backups, there was a… Read more
The log file tends to fascinate me. In fact one of my favorite posts is where I looked into the effect of VLF size on shrinking the log. So the other day I was asking about VLFs and got sent to this great video of a recorded session from… Read more
Maximale Anzahl Zeilen je Datenseite und minimale Datensatzgröße
Wie viele Zeilen passen eigentlich maximal auf eine Datenseite? – wenn die Datensätze/Records so klein wie möglich sind.
Zunächst, Part 1, was ist der kleinstmögliche…
0 comments, 214 reads
Posted in Andreas Wolter SQL Server & BI blog (English / German) on 29 October 2014
Originally posted on MSSQLFUN:
Database Mirroring works on transaction logs. It applies transaction logs from Principle to Mirror. But Operation like addition of file is no log operation because of that file not be added to Mirror automatically.
Steps to Add Database File on Database involved in DB Mirroring…
So far this has been a fun and rewarding dive into Elysium to see and chat with these entities. We have unearthed some means to be able to… Read more
I committed to studying for MCSA SQL Server 2012 and taking the certification exams by the end of the year…last year. That didn’t happen. At the start of this year, I made that same commitment again. Neither did that happen. At that time, I told myself there’s still a lot… Read more
By Steve Bolton
…………Using SQL Server to ferret out those aberrant data points we call outliers may call for some complex T-SQL, Multidimensional Expressions (MDX) or Common Language Runtime (CLR) code. Yet thankfully, the logic and math that underpin the standard means of outlier detection I’ll delve into in… Read more