Always an interesting topic — GUID keys. Actual Emails: More Grief for GUIDs – SQLServerCentral.
Through much of this SQL Server phase of my career I have been both developer and DBA. Yes, I have had these conversations with myself, but it’s time now to think about when the DBA is someone else. Five Rules For Successful Conversations With DBAs – SQLServerCentral.
Script Table Data – I have used other tools to do this for ages. I can’t believe that I never knew that it existed in SQL Server Management Studio. Script Table Data In SQL Server Management Studio.
simple talk: Agile Database Development. Agile methodologies work well with database developments only if great care is taken to do things right. It requires good judgement and leaves little room for error. Dev Nambi, in an extract from the book Tribal SQL, argues that Agile works for smart, curious, and experienced software … Continue reading →
Indexed Views – SQLServerCentral. This post describes an interesting feature that I have never been able to use. Unfortunately, indexed views come with a fairly long list of restrictions and I always seem to run afoul of at least one of them.
New Tool: Microsoft® SQL Server® 2012 Performance Dashboard Reports | Blog | SQLServerPedia.
For the last few weeks, on and off, I have been experimenting with setting up SharePoint 2013 Enterprise in order to explore its Business Intelligence features. Maybe you can just read about it and understand, but I need to try things. … Continue reading →
Performing a clean installation of SQL Server 2012 SP1 on the (new) production servers seems to have resolved a number of issues relating to MDS. … Continue reading →
My upgrade to SQL Server 2012 SP1 from CU4 went well except for one glitch. After the upgrade was complete, MDS showed no models! … Continue reading →
After installing SQL Server 2012 SP1 on your workstation, an update to SQL Server Data Tools is required before Visual Studio 2010 SP1 can again open BI projects. You can find the SSDT update links for VS2010 and VS2012 here. … Continue reading →