Browse by Tags
All Tags »
SQL Server (
RSS)
I don't know if you've noticed it, but I don't blog all that much lately (I know blog, I know - but that doesn't mean I don't love you!). So as you may gather that if I do blog, it must be something that seems important to me. The SQL Server Team has recently blogged about an initiative they're doing with the Pragmatic Works Foundation . Pragmatic Works Foundation is a non-profit that provides free technical training to veterans, the jobless, and underemployed. In 2012 they're...
The Microsoft BI Conference 2008 has been the source for quite a few announcements. First of all, now that DATAllegro was purchased by Microsoft, the talk is about SQL Server handling bigger amounts of data. There have been posts not just about terabyte projects, but also petabyte projects. The full integration of DATAllegro's technology into SQL Server is planned for the first half of calendar year 2010 and is code named Project Madison. SQL Server 2010 itself is code named Project Kilimanjaro...
I came across two very interesting web sites lately, both of which are a great source for good webcasts. The first site is Learn Microsoft BI which has all sorts of video on BI projects and how to develop them using SSAS. There has actually just been a first video on PerformancePoint Server as well. The site requires registration, but is well worth it. The other site is SQL Server Videos which targets more DBAs and developers. Having done just a few webcasts and knowing how much work goes into it...
Webcast: צעדים ראשונים ב Reporting Services 2008 אני חושבת שהבאזז סביב SQL Server 2008 כבר הדליק את כולנו. אני החלטתי להתחיל ולבדוק את מה שקיים כבר במערכת ודבר ראשון, החלטתי להתחיל עם Reporting Services 2008 . ב Webcast הזה, אני אראה איך בונים דוח בסיסי עם הממשק החדש. View Video קובץ ה WMV להורדה לינקים מהסרטון: לאתר Reporting Services 2008 כאן לפורום של MSDN ישראל לשאלות ותשובות בנושא SQL Server כאן להורדת דוגמאות ל Reporting Services 2008 כאן להורדת הסקריפט בו אני משתמשת בסרטון כאן
Webcast: First Steps in Reporting Services 2008 [EN] I think the buzz around SQL Server 2008 has got us all interested in learning more about the product and what it has to offer. I personnaly, decided to learn first more about Reporting Services 2008 . In this webcast, I'll show you how to work with the new interface and build a basic report. View Video To download the WMV file The links mentioned in the webcast are: The Reporting Services 2008 Site here The MSDN Forum for Q&A on Reporting...
SQL Server Data Services - SSDS Well I guess this means that soon enough we'll all have to know some new initials... Microsoft has announced in MIX08 about SQL Server Data Services ( SSDS ). SSDS is a new, web-based, on-demand data storage and query processing utility services. SQL Server Data Services is built on SQL Server database and Windows Server technologies and Microsoft promises scalability and security in this new service. Just so as to promise they're keeping up on all ends, SSDS...
If you were wondering where to turn to check on your latest SQL Server question, then wonder no more! MSDN and TechNet are now linked for all their information regarding SQL Server. I like it best when I don't have to choose ;)
Yes, it's true, it's finally here! The latest version of Microsoft SQL Server 2008 CTP just got released and it includes all sorts of goodies – especially for us developing on SSAS. The general highlights include: T – SQL intellisense Geospatial Support Analysis Services MDX Query Optimizer - Block Computation Analysis Services Aggregation Design Lookup Enhancements for SSIS Robust Report Server Platform Microsoft is urging you to download it and send them feedback so as to refine and enhance...
CU 4 was released yesterday, and as in previous versions, contains the hotfixes that have been developed since the release of SP2. Like with cumulative update 3, this one is also multilanguage and is available through writing a request to Microsoft Online Customer Services at http://go.microsoft.com/?linkid=6294451 . To install cumulative update package 4 for SQL Server 2005 Service Pack 2, you need to enable the SMO and the SQL-DMO stored procedures. The cumulative update is also known as build...
I thought this time around, we'll discuss how solve order can affect your MDX calculations. I found that people tend to ignore this property, as it is not mentioned in the "Form View" of the Calculation Tab of the cube (which is what people usually tend to use when they write MDX for a cube. I hope this will be taken into consideration in SQL Server 2008). Now, this is a shame, as solve order can greatly affect your calculations. For each calculation you do in MDX, you can specify the optional property...
There are quite a few ways of ways of documenting the changes a business entity goes through over time. The most famous of them all (and the most difficult to build) is a Slowly Changing Dimension (SCD) type 2. doing this in a table, you would create a table which would include: an incremental key, the business key, the attributes you'd like to track for that entity, a start date and an end date (for which the information was right) and a flag which would equal 1 when we are looking at the last...
Goodness, it's feels like I just blinked there for a moment, and already Microsoft is releasing a new cumulative update for SQL Server 2005 SP2! The build of the cumulative update package is also known as build 3186. The knowledge base article is here and the download itself is available here , and you can download the version in which ever language suits you. And just so you don't think the guys at Microsoft are resting on their laurels, I would tell you that obviously, Cumulative Update #4 is already...
SQL 2008 July CTP is out! I started to get suspicious when my brother ( adlai ) called me and asked me "did you downloaded the SQL2008, because I can't download it now ! the link in MSDN doesn't function". With SQL Server 2008 July CTP release, customers can understand and get hands-on experience with the new capabilities that, with the release of SQL Server 2008, will help them support their mission-critical platform and enable pervasive insight across the enterprise. SQL Server 2008 lays the groundwork...
Hi everybody, What’s up? Thought I’d share with you something strange I found while using named queries in the DSV layer in SQL Server Analysis Services. I have developed quite a complex layer of connected tables in my DSV. As development had evolved (with the customers demand) I found myself turning 3 of my regular tables into named queries. The named queries were basically using the same table twice in an inner join to compare the state of the entity in two different times in the table. After this...
About a week a go (I admit I'm only catching up to it now…) Microsoft released the SQL Server 2005 Best Practices Analyzer . The tool analyzes and monitors the SQL Server Profiler files. It uses a predefined list of recommendations to determine if there are potential issues in the database environment. Now if you're like me, then after downloading and installing the tool, you can't help but think to yourself "yeah great, but how do I use it?..." Well all you need to do after that is run the SQL Server...
More Posts
Next page »