Actual Emails: More Grief for GUIDs – SQLServerCentral
Always an interesting topic — GUID keys. Actual Emails: More Grief for GUIDs – SQLServerCentral.
Continue reading →Tag Archives: SQL Server
Five Rules For Successful Conversations With DBAs – 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.
Continue reading →Script Table Data In SQL Server Management Studio
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.
Continue reading →Agile Database Development
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
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.
Continue reading →New Tool: Microsoft® SQL Server® 2012 Performance Dashboard Reports | Blog | SQLServerPedia
New Tool: Microsoft® SQL Server® 2012 Performance Dashboard Reports | Blog | SQLServerPedia.
Continue reading →Fun with SharePoint 2013 BI: When ‘uninstall’ is not an option
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 →MDS 2012 Installation Issues
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 →Disappearing MDS Model after upgrade to MDS 2012 SP1
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 →VS2010 SSDT Update Required after installing SQL Server 2012 SP1
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 →