Categories
Top Posts & Pages
- SSIS Script Task and Proxy Auto Configuration (PAC) Script
- HierarchyID datatypen
- Microsoft Visual Studio is unable to load this document
- Never loose your server list in SSMS again...
- Interessant tag cloud
- Slotskage i lyserød
- Rolling period with shell dimension SSAS
- Julian Date and Supplemental Month (budgeting)
- SQL Server Quick Tip 1 - 5
- Quick-tip: Default column type in SSMS
Recent Comments
- TSQL Tuesday #63 – How do you manage security: Rollup - SQL Server - SQL Server - Toad World on TSQL Tuesday #63 – How do you manage security
- TSQL Tuesday #63 – How do you manage security: Rollup - SQL Server - SQL Server - Toad World on TSQL Tuesday #63 – How do you manage security
- Donald Parish on Run your cubes in Warp Speed – Really Really Fast!
- Kenneth M. Nielsen (@DoktorKermit) on How to Process Multiple Dimensions via BIDS and SSMS
- Jens Vestergaard on Teradata based Data Source Views in Analysis Services
Tags
.Net 3rd. ed. AMO Analysis Services BI Business Intelligence Bønner C# Certificering Coffee D&D Espresso FAIL Fejl Humor Kværn MCP MDX MSConnect NFL Personal Powershell Presenting Roleplay Security SQL SQL2008 SQL2012 SQLBits SQLBits X SQLPASS SQL Server SQLServer SQL Server 2008 SQLTip SSAS SSIS SSIS 2008 SSMS SSRS T-SQL Teradata vandkøling VS2008 VS2010LinkedIn
I am happy to connect on LinkedIn:
Tag Archives: SSMS
Filtering SQL Agent Jobs
I suspect that any developer who has been near a SQL Server for more than just a short while, you will be able to recognize a list of SQL Agent jobs that can no longer can be seen in its full … Continue reading
Never loose your server list in SSMS again…
Having to install new laptops, re-install old ones, configuring virtual servers or whenever you get the opportunity to install SQL Server from scratch, you always end up with an empty list of servers, when you try to connect through SQL … Continue reading
Server and column collation conflicts in properties of a login
Problem: Error: Cannot resolve the collation conflict between “Danish_Norwegian_CI_AS” and “SQL_Latin1_General_CP1_CI_AS” in the UNION operation. (Microsoft SQL Server, Error: 468) when clicking “Securables” in properties of a server login. Setup: Server is set up with collation: SQL_Latin1_General_CP1_CI_AS The database, or … Continue reading
SSMS Quick Tip
If you ever need to test Analysis Services roles, you can easily do so either by browsing the cube or by means of a query. When browsing a cube through SQL Server Management Studio (SSMS) or Bisuness Intelligence Developer Studio (BIDS), you … Continue reading
Posted in Programming
Tagged Analysis Services, BI, MDX, Security, SQL Server, SQL Server 2008, SSAS, SSMS, VS2008
Leave a comment
Quick-tip: Default column type in SSMS
Looking for some other settings I stumbled upon this very nice, and very hidden, feature in SQL Server Management Studio (SSMS): The ability to set your default column type! That should save me a lot of time, from now on.