The info below is from my book “David McCarter’s .NET Coding Standards” Let us face it, in most companies that programmers work for, we end up doing database work. I do not agree with this since I think the DBA or BIA should handle database programming and we should stick to what we do best… … Continue reading Database Naming Standards for the Programmer
Today I am announcing my new app called dotNetTips.Utility Dev App. With this app I combined my previous dev cleaner and dev backup apps into one with more features coming soon. Clean Visual Studio & SQL Server Temp and Cached Files This feature will quickly remove temporary and cached files created by Visual Studio and … Continue reading dotNetTips.Utility Dev App
Today, I was trying to create a diagram in SQL Server to setup table relationships. I kept getting an error. I gave my user owner rights on the database but that still did not work, until I found this: EXEC dbo.sp_changedbowner @loginame = N'sa', @map = false This fixed it!
The dotNetTips.Dev.Cleaner is an app that will quickly remove temporary and cached files created by Visual Studio and SQL Server. The reason I created this app is because from time to time Visual Studio builds will error for some unexplained reason, especially after getting new source from source control. It's because these temporary and cached files … Continue reading dotNetTips.Dev.Cleaner Utility
The dotNetDave Rocks The Nation Tour will stop in southern California at the SQL Saturday on April 26th. Lets Rock the OC! If you live in the area you need to attend the following session: Rock Your Technical Interview™ Have you ever not gotten a job because you weren’t prepared for the interview? Would you … Continue reading dotNetDave Rocks SQL Saturday #289 (Orange County)
I hope everyone in southern California is planning to attend this years SQL Saturday in San Diego, Ca on 9/15. It’s always a great time and lots of free training! I will be presenting the following sessions and I hope you will attend. Geeks Anonymous What do programmers really want? Do you work at a … Continue reading SQLSaturday #157 – San Diego
SQL Server 2012 has been released to manufacturing today! SQL Server 2012 will provide Mission Critical Confidence with greater uptime, blazing-fast performance and enhanced security features for mission critical workloads; Breakthrough Insight with managed self-service data exploration and stunning interactive data visualizations capabilities; Cloud On Your Own Terms by enabling the creation and extension of … Continue reading SQL Server 2012 Released!