IntelliSense in SQL Server 2008 can sometimes not be very intelligent. It’s there to help you can sometimes cause more problems than it does solve problems. Here’s one of those problems cases: Create a table without using the UI. Just type a basic script to create a table. Try to select from that newly created table and your IntelliSense can’t find the new table. The problem is SQL Server knows you have a new table but IntelliSense does not. If you refresh the Local Cache IntelliSense will be ba...
Read More
If you haven’t heard already this week there is a great free webinar series going on that’s meant for beginners. This series is meant to get you up to speed on many topics like TSQL, DBA Fundamentals, SSIS, SSAS, SSRS, and Performance Tuning. Oh and did don’t forget it’s free! It’s your opportunity to see speakers and authors like Jorge Segarra, Patrick LeBlanc, Brian Knight, Brad McGehee, Adam Jorgensen, and myself! All sessions are recorded so even if you miss the original filming you can down...
Many companies have a very rigid development lifecycle for all products or solutions they develop. Deploying to each of these environments (Development, UAT, and Production) can be a nightmare to maintain. Luckily there is a great feature in Visual Studio called Solution Configurations, which will allows you to toggle between which environment you want to deploy changes to. This feature should be already available by default in your Visual Studio but you may have never used it. As you can see it...
This week was an exciting teaching week for me. I taught the Pragmatic Works Foundation class, one of my favorite and most rewarding classes to teach. This class is designed to help individuals who have a passion for technology but do not have means to pay for training. We spend a week teaching basic TSQL and also some Reporting Services to give them a skill to make it easier to market each person for potential jobs. In this week’s class we had a wide variety of people with all completely differ...
You may have noticed a flux of new blog post entires yesterday from a group of people talking about the Pragmatic Works Foundation. This is a great group of people that are new to IT and learning the basics of SQL Server. Per our website: The Pragmatic Works Foundation was created to find passionate people who are interested in joining the technology field but cannot make the financial investments needed for training and hardware. Working with our job placement partners our goal is to place all ...
Reporting Services has many expressions that can manipulate date fields. These expressions can be used just about anywhere in SSRS including object properties, displayed data, and parameters. Recently I’ve worked on some projects that required date parameters to do things that you would typically see in an Analysis Services cube. My client needed to see data brought back Week to Date, Month to date, Year to date, and on with a rolling week. My first suggestion of course was to create a cube to n...