Microsoft has given us DBAs/Developers/etc. a wealth of free reports integrated into SQL Server Management Studio (SSMS) in order to see what is happening in our environment. These reports are really nice because you do not need to know the DMV/DMF in order to get the results.
The first report… Read more
Come join us Thursday April 2nd for an Excel BI virtual chapter session at noon central with Pragmatic Work’s Devin Knight who will help us get started with PowerQuery.
Thu, Apr 02 2015 12:00 Central Daylight Time
Getting Started with Power Query by Devin Knight
GETTING STARTED WITH…
In December, I was asked to write an article(s) on Database Refactoring. It started as 2 topics, but then consolidated into one. I really wanted to talk about the database design issues I see with a development department. Please give some time to reading the article and comment. First, I… Read more
I used to spend the 4th of July weekend (or week) in Austin with some buddy’s when we were in our 20s. There was so much to do and enjoy while there it is exciting to go back to this great city. Not only that, but there are some really… Read more
The Professional Association of SQL Server (PASS) has a slogan for what they do – CONNECT, SHARE and LEARN. So, what does this mean to me and the SQL Server professionals I have meet in this community (#SQLFamily)?
On Thursday, I was invited as a blogger to attend an intimate conversation (Q&A) with the PASS Board of Directors: Adam Jorgensen (EVP – Executive Vice President), Denise McInerney (VP Marketing) and Thomas LaRock (President). I started to try to understand why I was asked, but gave up due to… 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
Excel 2013 - We can’t create a Timeline for this report because it doesn’t have a field formatted as Date.
After getting excited about the Timeline object in Excel 2013, I tried to add this cool feature of Excel 2013 and got an error – “We can’t create a Timeline… Read more
This morning I received an email (really 3 emails) about an extension for voting for the Board of Directors giving anyone registered with PASS before June of 2014. I think this is fair and gives those that have been active, but did not update their profile a chance to… Read more
In case you do not receive the PASS connector, here are some announcements for this year’s summit on Nov 3rd – 7th.
Day 2 Keynote - Dr. Rimma Nehme from Jim Gray’s System Lab
Apparently, Dr. Mehme is a Polybase and query optimization expert from Microsoft and she will be… Read more
As always, there are many free ways to learn more about SQL Server and the Professional Association of SQL Server (PASS) free membership to Virtual Chapters is one of those ways.
Here is what I would suggest watching:
Next Meeting: Tue, Aug 12 2014
Bridging the Communication Gap Between…
PASS Data Arch VC presents SQL Server MVP Grant Fritchey - How to Build a Database Deployment Pipeline
Please come join the Data Architecture VC this Wednesday to get info from MVP Grant about Database Deployment something all DBAs should be doing to work with developers.
Grant Fritchey – Microsoft MVP
July 23, 2014 Noon CST
How to Build a Database Deployment Pipeline.
The pace of business accelerates…
Here is a list of upcoming webcast presented by various PASS Virtual Chapters that are always free. Some are recorded to view later.
Database Administration VC
Date: July 9
Topic: How to be a great DBA– sponsored by Dell Software
Registration: You must register…
One of the first questions I got while interviewing for a potential position as a DBA was “If there is performance problem, where is the first place you would look?”
Now at this time, I was trying to move from Software Developer to DBA, and I answered that I would… Read more
This will be the second SQLSaturday in Houston I have spoken at and I am excited about talking Execution Plans and Multidimensional Analysis Services. These are 2 topics I deal with on a daily basis, so it is great I get to help others understand these technologies.
I also get… Read more
So, I am flying home thinking about the event Saturday and many things are running through my head. No, not work on Monday. First, I would like to say that Hadoop is not going to replace SQL Server nor Business Intelligence. Second, a new thing is coming but it is… Read more
I am excited about being selected to speak and attend the May 3rd SQLSaturday BA Edition in Dallas, TX. There are a number of sessions I want to attend including Eric Mezell’s An Introduction to Hadoop, Andy Egger’s Applied Predictive Analytics, David Browne on Enterprise Business Intelligence (for lunch) and… Read more
Baton Rouge is now on its 6th SQLSaturday and the event grows year after year. It all started with Patrick LeBlanc back in 2009 with #17 http://sqlsaturday.com/17/eventhome.aspx and with help from local User Groups (William Assaf – Sparkhound), it has expanded its topics and attendees. This event is… Read more
After monitoring enterprise SQL Server instances for over 10 years now, there are 5 tools that are used every day for spot check views of a system. The order here is not a countdown from 5 to 1. They are presented here in no particular order, because each has its…
Theoretical versus real-world
There is not a strong need for developers to know the theoretical definition of 1st thru 5th normal form, but there needs to be an understanding of some design practices. The keys are:
- No Duplicate data in columns in one table
- Relationships built as…