Sitemap
- Home
- Artikelen
- Blogs
- SQL
- Speaking at Triangle SQL Server User Group 16 Mar 2010!
- The ethics of aggregating other peoples' content
- Survey: How much data do you work with?
- SQL Server 2005 SP4: What You Need to Know
- Good News for Women in Technology - Barbie Has Joined the IT Scene
- Create Outlook Appointments from PowerShell
- Survey: How's Your Economy?
- Ex Sun CEO: Steve Jobs Threatened Me, Too
- Who's Using Resources on My Server?
- Instant File Initialization for SQL Server 2008 (and 2005)
- Spotted on SproutDaily.com
- Restartable or Rerunnable SSIS Packages
- My Calculated Member is slow
- Which cube browser for Microsoft OLAP
- Big Queries
- SQL Server Analysis Services Partitions
- Dynamic OLAP Reports
- How to Avoid SQL Reserved Words
- MDX is a redundant language
- Optimizing Basket Analysis
- Excel 2007 OLAP PivotTable Tips
- What's preventing Excel from being the ubiquitous cube browser
- Are Temp Tables Bad?
- The Transaction Manager is not available
- Circular Relationships
- Get Active and Eat Well
- When to use clustered indexes
- Using Profiler to tune a SQL Server data warehouse
- Using Profiler to tune a high volume transactional application (written with stored procedures)
- SSIS Slowly Changing Dimension SCD Wizard is Too Slow
- I like PerformancePoint Dashboards
- Aggregations Won't Fix Cube Performance
- You Too Can Learn About R2
- T-SQL Tuesday #4: I/O, You Know
- T-SQL Tuesday - IO capacity planning
- What SPN do I use and how does it get there?
- Consolidation Strategy References
- Survey: T-SQL Source Control?
- SSIS, the KSCD and Ascending/Descending Sort Order
- Microsoft Tweaks Browser Ballot
- T-SQL Tuesday #004: Real World SSD’s
- T-SQL Tuesday #004: Real World SSD’s
- T-SQL Tuesday #004: Why Doesn't TDE Encrypt My FILESTREAM Data?
- T-SQL Tuesday #004: Why Doesn't TDE Encrypt My FILESTREAM Data?
- Troubleshooting Application Timeouts in SQL Server
- Troubleshooting Application Timeouts in SQL Server
- Bad habits to kick : ignoring I/O
- Bad habits to kick : ignoring I/O
- T-SQL Tuesday - Query Cost
- T-SQL Tuesday - Query Cost
- Why abbreviate schema names?
- Why abbreviate schema names?
- Script Data in SQL Server 2008
- It’s OK to take a Shortcut Sometimes
- SSIS Snack: Grid Data Viewer
- Apple Delays iPad Release
- Apple Delays iPad Release
- Geek City: More About Nonclustered Index Keys
- Bad habits to kick : creating the uber-view
- OT: Thanks to Two Past Mentors
- SQL Saturday #33 : slide deck, recap and shout-outs
- My Thoughts on SQL Saturday #33
- Default value for OLE DB Destination FastLoadMaxInsertCommitSize in SQL Server 2008
- Twitter will migrate from MySQL to Cassandra DB
- Now I've seen everything: A database with a Y10 bug...
- Keep Your Data Clean
- Quote of the Day – On Reputation
- Human Doings
- WinInfo Short Takes: Week of March 8, 2010
- WinInfo Short Takes: Week of March 8, 2010
- Evaluatieformulier
- BI Consultant van het jaar – Kasper de Jonge
- SQL Server 2008's MERGE Statement
- Speaking at SQLSaturday #33 in Charlotte
- ROI and the DBA
- SSIS Snack: The Trash Destination Adapter
- Monitoring SQL with SCOM 2007 Least Privilege Access
- SQL Server 2008 R2 - Application and Multiserver Management Learning Materials
- Windows-7-300-Million-Units-Expected-in-CY-2010
- Windows 7: 300 Million Units Expected in CY 2010
- RSA: Microsoft Proposes PC Safety Online
- RSA: Microsoft Proposes PC Safety Online
- Call for long term strategy in Microsoft BI Client
- Could Piracy Limit Sources of SQL Server Help?
- Could Piracy Limit Sources of SQL Server Help?
- Another bad habit to kick: checking variables in DML operations not just before
- Subscription Views - Part 3: Padding Level-Based Views
- Subscription Views - Part 2: Combining and Customizing Views
- Publishing Master Data with Subscription Views - Part 1: The Basics
- Presenting at Calgary PASS in March
- Apple-Launches-Attack-on-Google-s-Android
- Apple Launches Attack on Google's Android
- No Certainties, Including That One
- Bookstores and Databases
- SSIS Snack: Data Preview
- My first encounter with SmartAssembly
- Setting SQL Server ErrorLog Retention and Rollover with Powershell
- Microsoft to Offer Office 2010 Tech Guarantee
- Microsoft to Offer Office 2010 Tech Guarantee
- Windows-7-Over-90-Million-Sold
- Windows 7: Over 90 Million Sold
- Extensive library of Excel functions for SQL Server
- Do more with less: the missing feature in Excel Services
- EU: Browser Ballot to Serve 100 Million
- EU: Browser Ballot to Serve 100 Million
- Using SQL Server 2008's EXCEPT and INTERSECT Statements
- Ten years of SQL Server
- SQL Saturday - March 6 in Charlotte
- Have you backed up your keys lately?
- SSIS Snack: OLE DB Destination 1
- SQL Server isn’t the Big Brother to Microsoft Access
- Increasingly-Microsoft-and-Google-to-Battle-on-Legal-Issues-Too
- Increasingly, Microsoft and Google to Battle on Legal Issues Too
- SSIS - Package design pattern for loading a data warehouse - Part 2
- QueryUnit v 0.0.0.7
- Outputting data to an XML file : SSIS video nugget
- Using Windows Authentication from a non-domain joined machine
- WinInfo Short Takes: Week of March 1, 2010
- Agile in Business Intelligence? Of Course!
- FBLook Brings Facebook into Outlook
- Outlook Recognizes Simple Date Formulas
- Customizing Calendar Day View
- Quote of the Day – On Change
- I Don't Work On My Car
- WinInfo Short Takes: Week of March 1, 2010
- Calculating Holidays in SQL
- finally-eu-trains-antitrust-sights-on-google
- microsoft-s-mark-souza-lists-his-favorite-sql-server-2008-r2-features
- Microsoft Shuts Down Massive Botnet
- Microsoft's Mark Souza Lists His Favorite SQL Server 2008 R2 Features
- Microsoft's Mark Souza Lists His Favorite SQL Server 2008 R2 Features
- More on Going Backup-less with Exchange 2010
- Finally, EU Trains Antitrust Sights on Google
- Microsoft Shuts Down Massive Botnet
- PowerShell Version Two – Get Continuous Perf Counters
- expressor software Webinar: Improving Data Integration Performance - 11 Mar 2010
- Looping over SQL scripts and executing them : SSIS video nugget
- New on SQLPASS.ORG - Dealing with Micromanagers
- intel-also-target-of-cyber-attack
- Q: What are the different Windows Logon Types that can show up in the Windows event log?
- Intel Also Target of Cyber-Attack
- Weekly Challenge – Tools for Thought Site
- I Hope To See You at SQL Saturday #33 In Charlotte, NC 6 Mar 2010
- ODBC Multiplatform Survey - Microsoft needs your input
- The All New SQLMag Blog Pages - With Over 5 Years of History
- SSRS DataSet Filter - "Like" Operand
- Want Spy Novel Twists in a True IT Journalism Story? Read this...
- Amazon, Microsoft in Patent Cross-Licensing Deal
- SharePoint 2010: Microsoft's Thomas Rizzo Talks Details
- SharePoint 2010: Microsoft's Thomas Rizzo Talks Details
- How It Works: SQL Server 2008 NUMA and Foreign Pages
- quest-software-offers-free-dynamic-management-views-training
- microsoft-starts-enterprise-push-for-windows-7
- Quest Software Offers Free Dynamic Management Views Training
- Converting Data Types
- Quest Software Offers Free Dynamic Management Views Training
- SharePoint 2010: Microsoft's Thomas Rizzo Talks Details
- Do You Have Hidden Cache Problems?
- Amazon, Microsoft in Patent Cross-Licensing Deal
- Microsoft Starts Enterprise Push for Windows 7
- Lessons from Volunteering
- WiX 3 Tutorial: Generating file/directory fragments with Heat.exe
- Metaproblem: Terror
- Cumulative Update #8 available for SQL Server 2005 SP3
- Also Speaking at SQL Saturday #33
- Discount offer on Expert Cube Development book
- Bad habits to kick : using ancient copies of Books Online
- It will happen on a spring day in May...
- How to get Microsoft to speak at your event
- Azure MSDN Roadshow - Richmond, VA - 3 Mar 2010
- Intelligent Stats Updater
- Efficiently Clone Databases
- Introducing Identity Lifecycle Manager 2
- Buyer's Guide: Systems Managment
- TCP Offloading again?!
- With Regulatory Approval, Microsoft/Yahoo! Deal Moves Forward
- With Regulatory Approval, Microsoft/Yahoo! Deal Moves Forward
- SQL community events in Adelaide this week
- Why move a blog?
- The DB Taste Challenge
- Speaking at SQLSaturday #33 in Charlotte, NC : 2010-03-06
- MacGyver Moments
- Rocky Mountain Tech Trifeca next Saturday, and I will be there with no bells on (I promise)
- And finally the "by design" issue has been fixed.
- Did you start your SQL Server Engine correctly?
- Pivoting Without Aggregation
- A Strategy for Dealing with SSIS in Clusters
- The Evolution of SQL Server BI
- Move Database Files Without Taking the Database Offline
- I/O I/O It's Why My Server's Slow
- Running PowerShell Scripts Is as Easy as 1-2-3
- Get, Set, and Clear Computer Descriptions With Ease
- Troubleshooting CPU Spikes in the System Process
- WinInfo Short Takes: Week of February 22, 2010
- RSS feed for SQL Server Connect feedback
- Creating a Bing Map URL with a Business Rule
- Quote of the Day: On Finding It Out
- SSIS Snack: Conditional Split Outputs
- Book Review - oldie but a goodie - Inside SQL 2005 Query Tuning and Optimization
- SQL Server Reporting Services: Should support include files
- BI Dutch congres – programma en locatie
- Yet another example of defensive query optimization
- New Features in Office 2010
- Outlook to Integrate with Social Networking Services
- Enabling Human Workflow – Part 4: Creating the Business Rules
- Restarting the SQL Server Service Account – Why?
- Database Deployment
- The Query Optimizer and Cost Estimation
- Microsoft CSS once again a big part of SQL European PASS Summit…
- Optimizing a query, then documenting assumptions in a unit test.
- Mainstream vs Extended Support and SQL Server 2005 SP4: Can someone explain all of this?….
- Composing XML from HIERARCHYID in T-SQL
- Pair of PowerShell Editors Pack a Punch
- Four "Heads Ups" for Hyper-V
- Q: In Windows Server 2008, there's a feature that lets you use the Directory Service Restore Mode (DSRM) administrator account and password to log on to a Server 2008 domain controller (DC) at any time. What's this feature for and how do I enable it?
- What SharePoint 2010 Offers Online
- Other PowerShell Development Tools
- After Hotmail Outage, Privacy Fears
- NOEXPAND Hint – Give your feedback!
- Enabling Human Workflow – Part 3: Configuring Email Notification
- Can’t Travel for Training? No Problem
- WiX 3 Tutorial: Understanding main WXS and WXI file
- Software is Organic, Part 1
- SharePoint 2010 Stacks the Deck with Improvements
- SAN 101 for the DBA
- A foolish consistency is the hobgoblin of little minds?
- The Concepts Behind Time Calculations in SSAS
- Optimizing Time-Based Calculations in SSAS
- Nokia, Intel Partner on Next-Gen Mobile Platform
- Code that Writes Code - A Good Idea or Not?
- Enabling Human Workflow – Part 2: Granting permission to your data
- Is it possible to have multiple sets of key columns in a table?
- SSIS Snack: SSIS 2005 Lookup Transformations 101
- Connect Digest : 2010-02-16
- Bad habits to kick : inconsistent table aliasing
- tempdb in RAM
- Mind that collation : SSAS
- Microsoft Announces Windows Phones 7 Series
- Enabling Human Workflow – Part 1: Changing your model
- Challenge for the day: Learn One New Visualization
- SQL Server 2005 SP4
- FlickrFetchr - great little Mac app to download flickr sets (supports Guest Passes!)
- Managing Analysis Services Activity
- Service Packs... Coming to a Download Near You!
- Managing Analysis Services Activity
- Managing Analysis Services Activity
- CozyRoc demonstration videos
- Don’t take the SSMS login for granted!
- SSMS tips: Okay, it’s an SSMS trap!
- Did You Know? I just finished my first online seminar
- My CodePlex Wishlist
- WinInfo Short Takes: Week of February 15, 2010
- [OT] : Headed to the Olympics
- OT: Motorcycles and Access
- Bad habits to kick : ignoring the principle of least privilege
- Quote of the Day - What is important?
- The Right Question
- SQL Heartbeat – my favorite free tool
- SQL Saturday coming to Chicago on Apr 17!
- Going Backup-less with Exchange 2010?
- Choosing a Smartphone: The Features
- Google Jumps Into Social Networking Fray (Again)
- Busting a persistent myth: views are executed "before" enclosing queries
- SQL Search - free tool for searching your SQL Server
- The SQL Server Health Check
- WiX 3 Tutorial: Solution/Project structure and Dev resources
- SSIS Snack: Configuring a Conditional Split
- Pay Attention to Maintenance Cleanup Job Configuration (If you use Maintenance Plans)
- Staging Examples and Troubleshooting
- Bad habits to kick : blind SQL Server installs
- Importing Data by Using the Staging Process
- SQL Server Comparison and Synchronization Tools
- Calculating Concurrent Sessions, Part 3
- Q: How can I find the Windows Server 2008 event IDs that correspond to Windows Server 2003 event IDs?
- Windows Installer at a Glance
- Get Information About .msi Files with Just a Few Clicks
- Smart Phone Market Share: Android Posts Huge Gains, Windows Mobile Not Hopeless
- Unsupported and/or undocumented features
- Start a SQL Server Agent Job using the SQL Server PowerShell Provider
- Roanoke Code Camp is 13 Mar 2010!
- Almost T-SQL Tuesday #003: Calculating Products - An Oldie But Goodie
- T-SQL Tuesday #3: Database Relationships
- T-SQL Tuesday #3: SQL Server Relationships
- Free Training for You, Punishing Workload for Me. Thank You for Enjoying My Misery.
- Microsoft Warns of Windows Version Expirations
- Shredding XML into HIERARCHYID Take 2
- Kerio Connect 7 Eases Collaboration and Management
- Of Microsoft and Innovation
- Revive Deleted AD Objects with Active Directory Recycle Bin
- How to relate tables in DAX without using relationships
- Help for SQL Server
- SSIS Snack: Configuring an SSIS 2005 Lookup Transformation for a Left Outer Join
- BI Consultant van het jaar – er kan gestemd worden
- Bad habits to kick : relying on undocumented behavior
- Calling All Web Developers
- T-SQL Tuesday #002: The Roundup
- Confirmed: Battery Life Issues Not Windows 7's Fault
- Battery Life Issues Almost Certainly Not Windows 7's Fault
- Convert FILETIME to SYSTEM time using T-SQL
- SharePoint Teams Up at the Olympics
- SharePoint Teams Up at the Olympics
- Make it Easy for People to Help You
- Speaking about Indexing
- Metaproblem: Drama
- Think before unchecking sysadmin rights of BUILTIN\Administrators.
- Bad habits to kick : putting an IDENTITY column on every table
- Injection is not always about SQL
- NJ .NET User Group Presentation: Building a SQL Server Search Engine in .NET
- DevWeek and PASS Europe
- “sys2” scripts are growing
- SSAS Calculated Measures for Business (III): Average Inventory
- Connect Digest : 2010-02-06
- It's Official - SQLSaturday is Coming to NYC!
- MVP Book - Many Thanks!
- Configuring a MDS load-balanced web farm using IIS v7 ARR
- SQL Saturday #33 in Charlotte!
- On filtered indexes and defensive coding
- PowerPivot Alpha Geek Challenge #2
- Quote of the Day: On What Really Makes Something True
- Interview with Andy Warren about SQL Saturday, PASS, and More
- Avoiding calculated column in DAX
- PowerPivot Alpha Geek Challenge #2
- WinInfo Short Takes: Week of February 8, 2010
- Killing a SQL Server thread? Don’t!
- When bad error messages happen to good people
- Multi-Monitor Support in SQl Server Management Studio 2008
- Southern Maryland GiveCamp and TBDDEOTP
- Zune HD Price Drop: Too Little Too Late?
- Table Denormalization Study in PowerPivot
- Creating and using a Time (not Date) Table/Dimension
- PASS 2009 Lifetime PASSion Award
- Creating a Simple Business Rule
- Visio stencils for SSIS
- Microsoft, OData and RDF
- Multi-Row Variable Assignment and ORDER BY
- How Does Microsoft Do IT?
- The Trouble with SSIS Sorting
- SQLPerspectives on SQL Server MVP Deep Dives
- SQL Search experience
- Microsoft Investigating Windows 7 Battery Problems
- Bing Will Be Profitable, Microsoft Says
- The impossible thing happened...
- The impossible thing happened...
- What 3 events Brought Me Here
- [OT] BabySmash is a Smash!
- Did You Know: Early Spring Warm Up in Florida!
- SQL Server PowerPivot: My Thoughts
- Windows 7 Success Doesn't Lift Businesses or PC Industry
- Online Certificate Status Protocol (OCSP) in Windows Server 2008 and Vista
- SQL Server PowerPivot: My Thoughts
- Windows 7 Release Candidate to Begin Expiration Process
- Don't get burned by replication of SQL Server files
- Your laptop may be ready for SSDs, but are your SQL Servers?
- Don't swap horses in midstream.
- Geekiest Sig Challenge
- Apple Entry into Market Means Higher eBook Prices
- Filtered Indexes Work-Around
- 3 SharePoint Links for SharePoint Pros
- Transparent Data Encryption and the Latest Data Breach
- The 15-Minute Meeting
- SQL Saturday Boston 2010
- Creating and Using Outlook 2007 Quick Parts
- Mailbox Intelligence: Understanding the Gist Communication Efficiency Tool
- Quick Reference: Interacting With Office in SSIS
- Geek City: More About Row Overflow Columns
- Management Studio Tips & Tricks, version 1.0
- Did You Know: My Online Seminar is Scheduled!
- PowerPivot Profiler
- Creating Entities using the MDS WCF API
- WinInfo Short Takes: Week of February 1, 2010
- Encrypt it in .NET/Decrypt it on SQL Server?
- How to have a Select All Multi-Value Cascading Parameter
- Quote of the Day: On Relaxing
- SQL Saturday #30 Postponed until 10 Apr 2010
- Preparing to Deploy Exchange 2010
- Facebook's New Settings Raise Data Privacy Questions
- Choosing a Smartphone: The Hardware
- Protecting Your Organization from Spear-Phishing
- Record Microsoft Revenues as Company Sells 60 Million Copies of Windows 7 in Quarter
- Elevating Kentucky
- Your work may not be lost
- FILESTREAM: Storing Binary Objects in a database – or not
- Some Logic: The Four States of Two-State Logic
- SQL Server Enterprise Edition and Windows XP, Windows Vista and Windows 7
- What Three Events Brought You Here?
- Question: Is NT AUTHORITY\SYSTEM a sysadmin in your SQL Server and Why?
- DYK: Restoring a Database Retains Index Fragmentation
- Sometimes it's the small things : match column names in subqueries
- Invitation to startup meeting for PASS Scania
- Data as Strategy
- Definition of a Great Team
- The Virtualization Stakes
- The Virtualization Stakes
- SharePoint Goes to the Olympics
- SharePoint Goes to the Olympics
- Apple Announces iPad
- Apple Announces iPad
- Microsoft: We're Still Not Making a Zune Phone
- Microsoft: We're Still Not Making a Zune Phone
- SQL: Removing a specific plan from the procedure cache
- Invitation to startup meeting for PASS Scania
- Convert binary value to string value
- Convert binary value to string value
- SQLFool has updated her index maintenance scripts and needs testers!
- Index Defrag Script Updates – Beta Testers Needed
- Paul Randal and Kimberly Tripp - Boston Area - March 29-April 2
- Use MSAs to Ease the Pain of Administering Service Accounts
- The Smart Tablet Phone Thingy
- Create Professional, Beautiful Resumes for Free
- Using Active Directory Administrative Center in Windows Server 2008 R2
- Thanks To Strong Mac Sales, Blockbuster Quarter for Apple
- Attaching a Database
- SQL Server developers factsheet
- On Writing
- Unlocking Your Hidden Data Potential
- Get date from ISO week number
- Three Big Things That Got Me Here
- Memory Considerations about PowerPivot for Excel
- Microsoft Reorg Finally Combines Zune and Xbox, but What About Windows Mobile?
- Tracking SQL Server Time
- Speaking at SQLSaturday #30 in Richmond
- Setting up Database Mail to use Gmail account for Presentations
- SSIS Snack: Passing Parent StartTime to the Child Package
- Top 5 Reasons Your Company Should Consider SQL Server PowerPivot
- Top 5 Reasons Your Company Should Consider SQL Server PowerPivot
- Paul's Picks
- 4 AD Management Tools
- Quickly Respond to Security Threats With Forefront Threat Management Gateway
- Decrypting : A question of morals, ethics, or both?
- Speaking at the Columbia SC Code Camp
- Speaking at SQLSaturday #34 in Boston, 2010-01-30
- Kimball Method Slowly Changing Dimension Component v1.5 Released!
- Understanding Microsoft's Virtualization Technologies
- Letters
- Review: Sendio ESP 360
- Control Windows Features with PowerShell Cmdlets
- Celko Stumper - The Class Scheduling Problem
- Tweetpoll and RESTful Northwind go bye-bye
- New entry in the unbelievably-misleading error message category: Windows 7 x64 RDP Client
- Vancouver PASS January Presentation Recap
- What server is it trying to connect to?
- “Excel found unreadable content” when exporting a Reporting Services report
- Connect Digest : 2010-01-22
- WinInfo Short Takes: Week of January 25, 2010
- Using AD Recycle Bin For Mailbox Recovery
- Auto-tuning memory configuration on a cluster
- Quote of the Day: A Boyfriend Test (1)
- An Abbreviated History of Andy, Part 1
- OT: Mac++
- Did You Know? Three events that brought me here
- Gathering Deadlock Information with Deadlock Graph
- How Did We Get Here?
- Choosing a Smartphone: The OS
- Apple Tablet Obsession Reaches a Fevered Pitch
- How to get a x64 version of Jet?
- Hovering Over the Titles in Activity Monitor
- The Database Design Process
- SQL Server – Find the most expensive operations in Execution plans
- [OT] When Does Media Content -Truly- Become Public Domain?
- Correlated subqueries do not execute once per row.
- SQL Server 2008 R2 Release Date is Set for May 2010
- Tip: Index on Computed Column
- SQL Server 2008 R2 Release Date Announced
- Handling the Tree Path Request
- Free Microsoft E-Learning Courses
- Windows Server 2008 Hyper-V Security
- Windows 7 on a Netbook
- Microsoft Will Patch Internet Explorer Early
- Mis-steps in the publication of Cumulative Updates
- E-Discovery Q & A for Data Warehouse Administrators
- What is Slack Space?
- What Are Forensic Images and Forensic Copies?
- What is ESI?
- Q: Do I need to upgrade to Windows Server 2008 from Windows Server 2003 to get Alternative Name (SAN) certificate support?
- Performance Tuning Methodology Preferences
- Balance, Part 2
- New Interview and SQLMag ToolTime Blog Article on "SQLClue"
- Stored Procedure Contracts - Return Values
- "What three events brought you here?"
- Helping Haiti: Geeks Building Applications at CrisisCamp
- What three events brought you here?
- Saying Goodbye to Old Technology
- SharePoint in Vancouver, Vegas, and Los Angeles
- Reader Challenge January 2010
- Microsoft to Limit Bing Search Results Retention
- The Three Things that Brought Me Here
- New Cumulative Updates for SQL Server 2008 RTM & SP1
- SSIS Snack: SSIS, Excel, and a 64-bit OS
- Tuning ‘cost threshold for parallelism’ from the Plan Cache
- SSAS Calculated Measures for Business (II): Annualized Measures
- SQL Server 2008 R2: StreamInsight Development Models
- Stored Procedures - Time for a real contract?
- ABC Analysis in PowerPivot
- SSIS: Mo' Secure Configurations
- SYS2 DMVs on CodePlex
- Get a clue! A SQLClue, that is!
- Tools and Processes for “Fitting it all in”
- Balance, Part 1
- SQL Saturday #35 - Dallas
- PASS 2009 Session Evaluation
- Peeble Reports – Free reporting Tool
- SQL Server 2008 R2 - StreamInsight - Event Payloads
- When acquiring locks in the same order is not possible or not feasible.
- Bonus Post – The PASS Dakar
- Quote of the Day: On taking on something new
- Follow Me
- Iron and Cloud
- Securing Data Wherever Users Roam
- WinInfo Short Takes: Week of January 18, 2010
- Goals and Theme Word for 2010
- Poll: Hyperthread or not on 2 x 4 core Nehalem SQL Server?
- When you don't follow your own "bad habits" advice...
- Another Instance of Plagiarism
- The Database Design Process
- Presenting Database Design for Developers @RichmondSQL Tonight!
- Disaster Recovery Plan Testing 101
- Exchange Server and Uptime: The Search for More 9s
- HP Data Vault X510 Review
- Customizing SharePoint Site Templates
- Mac Falters As PC Growth Surges, IDC and Gartner Say
- Fooling the Query Optimizer
- Vote on Connect: Graphical UI for SQL Server Agent
- Q: Can I use a single Subject Alternative Name (SAN) certificate to secure access to multiple namespaces?
- Know Your Product Specifications
- PASS 2009 Evaluation Results
- Welcome to the blogosphere, Henk van der Valk!
- Google Threatens to Pull Out of China After Cyber-Attack
- VMware Buys Zimbra Cloud Computing Suite from Yahoo!
- Adding a PK online?
- PASS Session Evaluations
- The Awesomeness of ROBOCOPY Now at SQLMag
- The SQL developer gap (Warning: rant coming up)
- Getting Started with the Web Services API in SQL Server 2008 R2 Master Data Services
- T-SQL Tuesday #002: Is it XML, or Not?!?
- Ask and Ye Shall Receive: Lenovo Delivers a Netbook-Sized ThinkPad
- As Required, Microsoft Pulls Office
- SQL Server 2008 R2: Reporting Services - Pagination
- SQL Server 2008 R2: Reporting Services - RenderFormat
- Understanding the SSIS Package Protection Level
- SQL Server 2008 R2: StreamInsight Event Models - EventShapes
- Service Broker Basics - Part Deux
- Tool Tip - The Awesomeness of RoboCopy
- Brush Up on App-V
- T-SQL Tuesday #002: patterns that do not work as expected.
- Find alternate week day
- The “More Excellent Way” Experiment
- SQL Server - How many times is the subquery executed?
- Presenting at OPASS Today! (via LiveMeeting)
- T-SQL Tuesday: Easy Extended Properties
- TSQL2sday: Using sys.dm_exec_sql_text() to get the calling statement
- Downgrading from SQL 2008 to 2005
- T-SQL Tuesday #002: Non-aggregated columns in a GROUP BY query
- Connect Digest : 2010-01-11
- High CPU after upgrading to SQL Server 2005 from 2000 due to batch sort
- Discoverability and SharePoint 2010
- Microsoft's Plan to Save Windows Mobile
- Long Time Coming - my DW Server is Here!
- Long time SQL Cluster issue resurfaced
- Falsification as a Troubleshooting Methodology
- What is the more excellent way?
- PASS Virtual Chapters SSIS Presentations
- Is there and overhead to RPC events?
- SQL Server 2008 R2: What is StreamInsight used for
- Parent-Child Build Scripts with SQLCMD
- Y-2.01K Bug
- The Region: Sofware Industry Predictions for 2010: iPhone General-Purpose Applications
- Windows 7 GodMode
- SQL Server 2008 R2: StreamInsight AdvanceTimePolicy.Adjust
- SQL Server 2008 R2 - Departmental applications?
- Did You Know? I'm doing online seminars!
- Important SQL Server and Windows “End of Support” Dates you should know about….
- What You Need to Know About the Microsoft Forefront 2010 Products
- What You Need to Know About Windows Azure
- WinInfo Short Takes: 2010 CES Special Edition
- Finding Implicit Column Conversions in the Plan Cache
- DBCC CHECK commands encounter problems and reports errors
- The reviews are in…and I still have things to improve…
- Retrying after deadlocks leads to lost updates
- PASS Summit 2009 Evaluations
- Would you optimize SQL for less performance?
- Quote of the Day: The man who needs a vacation
- Presenting at Southern Maryland .Net User Group 11 Jan 2010
- Replace data of one table with data of other table
- Dev and Prod Systems, Using a HOST file to ensure your datasource is pointing the right system
- Collapse date range, with safety date range
- sys2 scripts updated
- Exchange Server Archiving for E-Discovery
- Microsoft Provides Muted Opening to 2010 CES
- New England Data Camp v2.0 (SQL Saturday #34): The Almost-Final Schedule
- Plan and Prepare or Just Do It? How about Both!
- PASS Summit Evaluations
- Aankondiging BI Dutch jaarcongres
- Take That, iPhone: Google Unveils Nexus One Smartphone
- MERGE and OUTPUT – the swiss army knife of T-SQL
- Service Broker Basics
- What Makes a Strong Community?
- Spit it out already!
- SSIS Snack: Package Version
- SSAS Calculated Measures for Business (I): Introduction
- Doing More with Less in 2010
- How to Efficiently Search and Manage Event Log Data
- Microsoft Announces Office 2010 Pricing
- CES 2010 to Kick Off Amidst Apple Frenzy
- 2009: The Year in List Form
- Trace Logging in SQL Server 2008 R2 Master Data Services
- StreamInsight and Reactive Extensions to .NET
- Frankly Speaking
- Performance Counters? There’s a script for that.
- Right, Wrong, and Style
- My experiences upgrading 2005 => 2008
- Quick poll : what is your favorite Management Studio tip or trick?
- Microsoft doesn't play the (traditional) BI client game
- Add-Content and Out-File are not for performance
- Invitation for T-SQL Tuesday #002: A Puzzling Situation
- SharePoint MVP Predictions: The Lost Predictions
- Google Chrome Becomes Number Three Browser
- New Year’s Goals, not New Year’s Resolutions
- SSIS – Package design pattern for loading a data warehouse
- Visions, Quests, Missions
- What kind of DBA are you?
- Social Sunday: LinkedIn Update
- How CALCULATE works in DAX
- Interview Now Appearing on CSTech.com
- Create permutations, a simple way
- Getting off to a good start
- 2010 Themeword and Goals
- Quote of the Day: On writing the new year
- Closing out 2009 – Goals in Review
- Year in Review: My Series on Building Developer Communities
- [OT] Auto-Responders: Making E-Mail Suck, One Reply at a Time
- [OT] Happy New Year
- WinInfo Short Takes: New Year Special Edition
- Got a slow holiday seaons? Why not spend it learning?
- The Beauty/Danger of Checklists
- Connect digest : 2009-12-31
- Outlook 2010 Will Use Word 2010 HTML Rendering Engine
- Yammer in Outlook 2007
- Happy Holidays
- Dimension cubes
- ‘Cannot Generate SSPI Context’ and Service Account Passwords
- Improving Your Public Speaking: "Confessions of a Public Speaker"
- Mobile Battle Heats Up Between Apple, Nokia
- New website online and sys2 scripts updated
- Measure Statement Performance with PowerShell
- Goodwill, Negative and Positive
- Using sa as owner for jobs and databases
- You're a mean one...
- Good Bye BI
- Backup SQL Server 2005 and 2008 Databases
- Diskeeper 2010 Update
- Microsoft Begins Delivering Word Patch
- SQL Server Chargeback Strategies
- Mixing OLTP and reporting using indexed views
- Util procedure to show database size
- Article: Scripting in SSIS - Part 1
- Tonight We're Going to Party Like It's 1999
- Microsoft BI Conference 2010 joins TechEd 2010 North America
- Playing with page compression - for real
- Microsoft BI Conference in New Orleans in 2010?
- Standard Point-in-time and time-interval representations
- Bad database practices: allowing apps to connect to the server hostname
- SQL 2008 - New Functionality to the dm_os_ring_buffers for Connectivity Troubleshooting
- Data is Just Data – Information – that’s another thing!
- Sorry, Apple: Kindle Was Number One This Christmas
- How Many SSIS Packages Should I Create?
- 2010 Microsoft BI Conference Details Surface
- 2010 Microsoft BI Conference Details Surface
- Hand-On IPv6 Lab Setup
- SharePoint MVP 2010 Predictions
- Did You Know? Yet Another Gift From Manning
- Cumulative Updates for SQL Server 2005 are available
- DATEDIFF with the Week Part
- Is The Paid-Article Website Dead?
- Presenting at Vancouver PASS in January
- Distinct Count Measure in PowerPivot using DAX
- Quote of the Day: On Christmas
- Cya 2009, Hello 2010, Last Decade of Tech
- Tracking Santa(?)
- Did You Know? A Holiday Gift From Manning
- PowerShell Demo Prompt
- Security Steps: Use AppLocker Policies to Block Solitaire
- OT: Stuff Happens
- Please do stop the beep…
- Seasons Greetings.SQL
- Troubleshooting a Failed Maintenance Plan
- It’s Data Tier Application and Data Application Component
- Thanks for Dreaming, Dr. Gray
- OWA Customization in Exchange 2010
- Q: Does Windows provide a mechanism to enforce the auditing of all file system or registry object actions that specific users or groups perform on a Windows system or domain?
- Backing up Azure Table Storage
- WinInfo Short Takes: Holiday 2009 Special Edition
- A Major Lesson to Learn from 2009 – Don’t Just Backup, Test Recovery
- Merry Christmas
- Staying Abreast of SQL Server Database Trends in 2010
- Monitoring SQL Azure For Performance
- A New Year's Resolution for 2010: Go European and Save Money
- 2010: More of the Same ... But in a Good Way
- Get an overview report on your log shipping setups
- Geek City: Exploring the Transaction Log Structure
- Profisee Webinar
- The best analogy for PowerPivot so far
- More than One Platform
- AutoArchive and DisablePST in Outlook
- SharePoint 2010 Lists
- French Court Finds Google Guilty of Copyright Infringement
- Intel Unveils New Atom Chips for Low-End PCs
- OData gunning for ubiquity across Microsoft products
- OT: Green Science and Bogus Mathematics
- Updates to the Wait Type Repository – PSS Blog
- Interesting Find - US Census Data for SQL Server 2008 (Codeplex)
- Considering SQL Azure
- SQL Server 2008 R2 Editions
- The Need for Self-Service Managed BI
- WinInfo Short Takes: Week of December 21, 2009
- The Transact-SQL Prime Directive – a bad example
- Quote of the Day: Let Go
- DBMail has Suddenly Stopped Working
- Is Perfect Software Possible?
- Join the DOTNETStories Contest
- Control Windows Features with DISM
- Letters
- Microsoft's Astrid McClean Discusses Exchange 2010
- Review: Encore Electronics ENNUS1 Network Server
- Using Active Directory Snapshots and the Dsamain Tool
- Sequels for SQL: Dec 17, 2009
- New Toys (Ho! Ho! Ho!)
- Be careful with constraints calling UDFs
- PerformancePoint applicatie security
- The Top 20 Questions in Database Design
- Measuring Social Media: Twitter
- Lies, Damned Lies and Statistics – Part III (SQL Server 2008)
- New Article on SQL Server Central: Using a Certificate Signed Stored Procedure to Execute sp_send_dbmail
- EU Drops Microsoft Antitrust Case
- US Government Sues Intel for Antitrust Abuse
- Bing To Go: Microsoft Delivers iPhone App
- Board Members at the 2009 PASS Summit in Seattle
- On software bloat...
- Spam Fighting and Lessons Learned
- The Coming Database Design Wave
- SSIS - Blowing-out the grain of your fact table
- How It Works: Are you handling cancels correctly in your SQLCLR code?
- My Greatest Weakness
- Performance impact: Speeding up SMO script generation – the test code
- Microsoft Joint Venture in China Plagiarizes Competitor
- Blog (Durnit!), Getting Started
- Ted Kummert on the SQL Server and MySpace Connection
- Get-ChildItem's -Include Parameter
- In Pursuit of the Practical IT Pro
- Windows 7 Under the Hood
- Find Files on Local Drives with Whereis.ps1
- It doesn't matter, it's just data...
- Like PowerShell for SQL Server?
- Cloud computing sounds good, but...
- Check Out My SSIS Screen Casts
- Data Deduplication Technology - New Article on DBTA
- Master Data Services team blogging
- Is it just me, or is this a flaw in SSMS?
- Welcome to the SQL Server Master Data Services Team Blog!
- Wizards are evil – wait, no they aren’t!
- Search a value in character column of all tables
- Why You Need Windows Server 2008 R2
- Is Google Making Its Own Phone?
- Performance impact: Speeding up SMO script generation
- Social Sunday: LinkedIn
- Connect Digest : 2009-12-12
- First take on Azure
- Quote of the Day: on Curiosity
- Blog (Durnit!)
- Double-Take Move
- WinInfo Short Takes: Week of December 14, 2009
- How well does your network work for you?
- Installing and Configuring Master Data Services 2008 R2 November CTP
- InvalidReportParameterException with Data Driven Subscription
- Protecting Exchange Server Data at Rest
- SQL 2008 Encryption EKM Virtual Event
- Fun and games with Reporting Services expressions
- Windows Server, Cloud Combined in Microsoft Reorg
- The Dark Sides of Consolidation
- New Features in SharePoint 2010
- What You Need to Know About SQL Server 2008 R2
- What You Need to Know About Office 2010 Public Beta
- A tale of CHECKDB failures cause by 3rd party file-system drivers
- Using RAW Files for Staging Data in SSIS
- Microsoft Fixes Zero Day Flaw in IE
- High CPU with Reporting Services 2008
- Review: Enzo Audit 2009
- Q: What types of disk configurations does BitLocker Drive Encryption (BDE) support?
- Presenting at Southern Maryland .Net User Group 14 Dec 2009
- T-SQL Tuesday #001 (Date/Time Tricks): The Roundup
- Problem with SQL Server service restart
- Problem with SQL Server service restart
- Rocky Mountain Tech Trifecta v2.0 - Denver Feb 27 – Call for SQL Speakers
- T-SQL Tuesday #001: Exploring "Fuzzy" Interval Islands Using SQLCLR
- To design or not to design?
- SSIS Package Builds
- Unambiguous date formats : T-SQL Tuesday #001
- T-SQL Tuesday #001: Splitting Date/Time Ranges and Intersections
- T-SQL Tuesday #001: Exploring "Fuzzy" Interval Islands Using SQLCLR
- T-SQL Tuesday #001: My Datetime FAQ
- SQL Server Date and Time fun from all around
- T-SQL Tuesday #001: A Couple SSIS Date Expressions
- T-SQL Tuesday #001: Yesterday it worked, today it's not working...
- OWA vs. Outlook in 2010
- SQL Server Master Data Services (Nov CTP)
- Knowledge is how you break the rules
- Managing Service Broker Conversations
- Security Steps: Delegate reset password on OU
- Waiting for an Apple Tablet?
- Copying Bing Now, Google Adds Real-Time Search
- For want of a nail
- Geek City: How Many Rows?
- Windows 7 - ASP.NET Temporary Internet Files, Assembly Redirects
- New England Data Camp v2.0 (SQL Saturday #34) - January 30, Waltham MA - Registration and Call for Speakers Open
- SQL Server Best Practices: Use Roles When You Can
- SQL Server MVP Deep Dives Release Surprise
- SSIS Logging Best Practices
- SharePoint and Social Networking: You Gotta Have A Purpose
- WinInfo Short Takes: Week of December 7, 2009
- Many-to-Many relationships in PowerPivot
- Project Houston
- Solutions to Logic Puzzle - Crossing a Desert
- Security Steps: NTFS and Share Permissions
- Odd that you can't create a filtered index on a deterministic persisted calculated column
- Performance impact: UNION ALL views, ANSI_PADDING, and bad query plans
- Windows 7 Family Pack Disappears in the United States
- Microsoft Makes Further Concessions to Opera in EU Case
- Quote of the day – just because I like this one
- Allowing for Gradual Source System Changes in ETL
- SSIS remote execution and SqlBulkCopy performance analysis
- Report Builder and Firewalls
- TwitterCache now hosted on SQL Azure
- Who is Active? v9.57: Fast, Comprehensive DMV Collection - What's Really Happening on Your Server?
- Guidelines and Best Practices in Optimizing LINQ Performance
- Disk2vhd: The Windows Troubleshooter's New Best Friend
- AT&T 3G Lawsuit Laughed Out of Court
- SQL Server Best Practices: Protect CmdExec
- Review: Sherpa Software's Mail Attender
- OT: Observations of how technology made things SO MUCH BETTER and how it doesn't help everything
- Book: Wally McClure - Building iPhone and iPod touch Applications for the .NET/C# Developer with MonoTouch
- Announcing SQLSaturday #30 in Richmond, VA!
- Timeout when deploying SQL CLR objects from Visual Studio 2005 or 2008 but not from Management Studio
- Should You Get a Droid?
- Simplify EFS Deployment
- Microsoft to Deliver Office 2010 in June 2010
- Internet Explorer Continues Usage Slide
- Plans are useless. Planning is essential!
- Remote Execution of SSIS Packages
- Removing unwanted characters - Part 2
- Why you shouldn't open .csv files in Excel
- Interview with Some SQL Server MVP Deep Dives Authors
- Moving Exchange to the Cloud, Part 1
- BIDN Launches
- Follow Up on Failed Connections and Threadpool waits
- How It Works: SQLIOSim CTRL+C vs Close Window
- After the Upgrade, it runs differently…
- SQL Server: Network packet size difference between returning XML and TDS
- How to get a date from Year, week and weekday
- SQL Server 2008 R2 RTM Date Still Not Certain
- Platforms Matter
- Paul's Picks
- Microsoft Investigating 'Black Screen of Death' Issue
- Microsoft: 'Black Screen of Death' Claim is Bogus
- Hoeveel architecten zijn er voor een BI project nodig
- Did You Know: You can Learn SQL Internals in Sweden!
- Upgrade to DTLoggedExec
- Logic Puzzle � Crossing a Desert
- SharePoint 2007 Updates and SharePoint 2010 Prereqs
- Reading Message Headers in Outlook
- Installing Outlook 2007 Business Contact Manager on Windows 7
- Excluding Words from Spell Check in Outlook 2007
- Black Friday Even with Last Year ... Does Cyber Monday Still Exist?
- Invitation to Participate in T-SQL Tuesday #001: Date/Time Tricks
- Aren’t DBA’s Just System Admins for Databases?
- SqlBulkCopy Performance Analysis
- VirtualBox eigenaardigheden
- Interview with Some SQL Server MVP Deep Dives Editors
- Virtual PC and Virtual Server hotfixes and updates
- DTLoggedExec 0.2.3.0 beta published!
- Debunking Kimball Effective Dates
- StreamInsight WILL be in SKUs other than Data Centre Edition
- Solving PowerShell Argument Input Errors with Wrapper Scripts
- Blog is Moving to a New Home
- Quote of the Day – On Thankfulness
- Ola Hallengren's maint procedures supports striping and Red Gate
- Giving Thanks
- The Magical World of SQL Server Licensing
- SQL Server Acronym Overload
- My new (fairly) tiny PC
- White elephant gift exchange for DBAs
- MDS Staging table error codes
- Sequels for SQL Server: The Week of November 27, 2009
- Connect Digest : 2009-11-25
- Master Data Services miscellaneous
- Found it!
- Temporary procedures : T-SQL
- Code that Writes Code
- Exchange Admin's Holiday Gift Guide 2009
- WinInfo Short Takes: Week of November 30, 2009
- Vancouver TechFest 2009 Recap
- Installation of SharePoint 2010 with PowerPivot on a single server.
- SQL Server 2005/Windows 2008 cluster issue when physical server names are in lower case
- Time to Get Green with "Bluejuice"
- Doctor, this SQL Server appears to be sick….
- SQL Server MVP Deep Dives - Something for your Christmas wish list ?
- Auto-create your Installation manual with the Problem Steps Recorder
- Kevin Kline Unplugged
- More about Calculating Concurrent Sessions
- Is Microsoft Just Like IBM?
- Time to Get Green with "Bluejuice"
- Cyber Threat Scanner
- Microsoft Warns of IE Vulnerability
- Some Ways To Look For Things in SQL Server Modules
- Changing the Primary Key After You Have Data
- Getting Less Stupid about HTML Code Formatting
- SQL Server Schema Automatic Revision History using DDL Triggers and SVN
- Q: Should You Present At Your Local User Group?
- Choices in physical storage design – EAV Case Study
- InstantCube: a DSL to design cubes
- Microsoft, News Corp. Discuss Locking Out Google
- SQL Server 2008 R2 installatie
- SharePoint 2010 and the Social-Networking Tsunami
- DeskCenter Brings SMB Systems Management to U.S.
- Replication Bug with Partitioned Tables
- DTLoggedExec 0.2.3.0 is coming….
- Twitter Search Term Extraction
- Microsoft Semantic Engine uncovered – the harnessing of unstructured data
- Windows 7 Problem Steps Recorder
- Microsoft Live Labs Pivot
- PASS Wrapup
- First sighting of SQL Server Master Data Services (MDS)
- Wrinkly Entropy
- Unable to run SQL CLR procedure with System.Security.SecurityException
- Connect Digest : 2009-11-20
- The Scope of Transaction Isolation Levels
- SQL Server 2005 Cumulative Update or GDR fails when trying to rename the mssqlsystemresource files
- PIVOting dense data may speed up your queires
- Is SQL Server 2008 R2 For You?
- Microsoft PowerPivot Resources
- Microsoft PowerPivot Resources
- Installing Service Packs / Cumulative Updates on a SQL 2005 cluster
- WinInfo Short Takes: Week of November 23, 2009
- Please Vote: Windowing Enhancements in SQL Server
- Playing with Disk Alignment
- Geek City: Intent to Update
- What is so bad about EAV, anyway?
- SQL Risk and Health Assessment Program (SQLRAP)
- 2009 SQL Server Magazine Editors' Best and Community Choice Awards
- Letters
- 2009 Windows IT Pro Editors' Best and Community Choice Awards
- Script to determine cardinality for index analysis
- DBCC CHECKDB for Very Large Databases
- Preparing for SharePoint 2010
- Anniversary at Database Trends & Applications Magazine
- PowerPivot for Excel Download Now Available
- To Deploy or Not To Deploy
- SharePoint and Office Betas Released
- PDC 2009: Microsoft Announces Office 2010 Public Beta
- PDC 2009: Microsoft Pushes Windows 7 to Developers
- Do you perform log backup for the model database?
- Building Your First Cube
- Lesson learned by Trial and Error
- Lesson learned by Trial and Error
- Parsing a string
- Insecure Metadata
- Trick Question -- Part Quattro
- How It Works: Controlling SQL Server memory dumps
- SQL Server Benchmarks November 2009
- New SQL Server 2008 Cumulative Updates are available
- Interop News: Datacom Unveils New 10Gb Data Filtering Taps and Switches
- Microsoft Offers First Peek at Feature-Complete Office 2010
- November Reader Challenge
- PDC 2009: Microsoft Launches Cloud Computing Platform
- PDC 2009 Opens: Mid-Week Short Takes
- Health Data Outcomes
- Trick Question -- Part Trois
- More Good Tools to Check Out
- Inside Story: How Microsoft's Open Source Code Theft Was Discovered
- Quest Software Introduces Foglight for SQL Server at PASS
- New IT Pros: Chart Your Career
- New Goodies from Microsoft - Microsoft Answers and Web Spark
- Design your Data Warehouse for Performance
- Clash of the Clouds
- Marketing Mistakes and Poor Customer Service can Hurt Your Business
- Automating UBO
- For Analysis Services users, you should be aware of this fix
- Connect digest : 2009-11-13
- SQL Server Agent - Query To Find Long Running Jobs
- SSIS 2008: Looping Through Rows in a Table
- Geek City: UPDATE Locks
- OT: Corrupted Outlook file
- How It Works: How many databases can be backed up simultaneously?
- iSCSI SANs Buyer's Guide
- Security Steps: Restricted Groups Policies
- WinInfo Short Takes: Week of November 16, 2009
- MDS is x64 only
- Presenting at Vancouver TechFest on Nov 21
- PASS Summit 2009 Recap
- Did You Know? I'll be teaching a public course in Florida!
- Demos: Connections, Fall 2009, Las Vegas
- SSAS: Errors in the metadata manager. The dimension with ID of...
- Sort transform arbitration [SSIS]
- Script to compare actual data length to column width
- SQL Server Makes Philanthropy Easy
- Passing NULL Parameters
- Bomgar Updates Remote Control Software
- VMware View 4 Doubles VMs per Core
- Exchange 2007 Will Run on Server 2008 R2 . . . Eventually
- Bing Partners with Wolfram|Alpha
- How to tell if you are running on a virtual environment
- How to disable Time sync on a VirtualBox VM
- The benefits of attending PASS realized!
- Database Engine Tuning Advisor and the Query Optimizer
- Geek City: Fragmentation and Forwarded Records in a Heap
- Some tips on SSMS Express Edition setup
- Backup compression no longer Enterprise edition only
- November CTP of SQL Server 2008 R2 : Download now
- The 5-Minute SQL Server Healthcheck
- Administer WSS 3.0 Content Databases from SQL Server
- Microsoft Delivers November 2009 Security Updates
- Microsoft Disconnects Xbox 360 Cheaters
- Replacing * with column names the easy way
- Where did that money go?
- Microsoft Fires Back at Deceptive Windows 7 Claims by Sophos
- SQL SERVER – 2008 – SCOPE_IDENTITY() and @@IDENTITY Bug with Multi Processor Parallel Plan
- Mid-Atlantic MSDN Roadshows!
- Plan and Execute an Active Directory Merger, Part 2
- Filtered Indexes
- Usage of Semicolons in SQL Server
- Bad Habits to Kick (T-SQL best practices)
- PASS Summit 2009: Extended Events Demos
- SQLBI experience at PASS 2009
- Fuzzy Logic and Regex come to T-SQL in SQL Server 2008 R2 – available now!
- SQL Server 2008 Master Data Services November CTP Released
- Minimally Logged Deletes - please vote!
- Multiple “clustered” indexes on a SQL Server table
- SQL Server 2008 R2 November CTP Now Available
- Exchange 2010 Availability Announced at TechEd Europe
- Microsoft Digital Forensics Tool Leaks Online
- Finding stored procedures containing %string%
- SpeakerRate.com
- SQL PASS 2009 Takeaways
- Recruiters and Hiring Managers on "Getting the Job"
- Top 5 Things You Can Do to Prepare for SharePoint 2010
- Notes from the Hiring Table, Part 4: Become the Ultimate Employee
- SQL Down Under show 45 - Jamie Thomson - SQL Server Integration Services (SSIS)
- SSIS Community Tasks and Components Site - One Year Later
- Should IT Professionals Refuse to Implement Scams (and #MYOBFail)
- Some updates to SQL Server 2008 SP1 CU4 you may not have noticed
- Task Factory Launch Party
- PASS 2009: Tom Casey Dives into the New SQL Server 2008 R2 Editions and SQL Azure
- Free book on Sharepoint-related Advice for SQL Server Administrators
- Did You Know: SQL Server Deep Dives launched at the PASS Summit
- PASS 2009 recap
- Another PASS has come and gone
- Bill of Materials – Computing Component Totals
- Made It
- SSIS Package Stats Collector version 2
- Bad database practices: abusing linked servers
- Bill of Materials – The Basics
- Connect Digest : 2009-11-06
- I didn't know you could do this!
- Elevating America in Maryland
- Elevating America in Missouri
- Subscription finally transferred
- NTFS Inheritance Rule Change
- Network Configuration Tasks with Netsh
- Security Steps:Use Syskey on Windows 7 to encrypt the SAM to stop someone resetting the local admin password on a netbook
- Supporting IPv6 in Your Windows Server 2008 Environment
- Retrieve Information from Open Browsing Sessions
- WinInfo Short Takes: Week of November 9, 2009
- Must survive ... one more ... day of PASS summit
- VMware Workstation 7 and Player do Windows 7 Aero
- Windows 7 Sets Sales Record
- Microsoft Completes Layoffs
- Blogging from the PASS Keynote : 2009-11-05
- More PASS Summit Awesomeness
- Live Blogging: Keynote at PASS, Day 3
- ADO.NET team wants to hear from you - survey open through November 13
- SSIS Logging - The PASS Session
- Live Blogging: Women In Technology Luncheon
- REDFLY Mobile Companion C8N Review
- File Sync, Backup, and the Pauli Effect
- Microsoft Preps New CTP for SQL Server 2008 R2
- MSN Gets Major Overhaul
- Quest DMV Breakfast Code – Disk IO
- Live Blogging: Keynote at PASS, Day 2
- Blogging from the PASS Keynote : 2009-11-04
- SQL Server PowerShell Extensions
- "Like OMG!" Moments from PASS Summit
- From my PASS Summit 2009 User Groups Presentation
- Defragmenting/Rebuilding Indexes in SQL Server 2005 and 2008
- What You Need to Know About Office Web Applications
- Microsoft: State of the Security Union is Good
- Live Blogging: Keynote at PASS
- Blogging from the PASS Keynote : 2009-11-03
- Get the Nth weekday of any arbitrary period
- 64-bit desktop virtualisatie: het Microsoft antwoord
- Microsoft Elevates America With Training Vouchers
- SQL PASS Summit 2009: New SQL Server 2008 R2 Editions Announced
- Microsoft Updates Cloud Solutions, Lowers Prices
- SQL Server 2008 features that work only in Enterprise Edition
- Superfast sequence generators!
- Extended Events SSMS Addin Update (1.0.2.62)
- Record winst voor Informatica
- The SQL Server Wait Type Repository…
- It's a Tough Economy Out There
- Issue with restoring 2000 backups on 2008
- SharePoint 2010's Sandboxed Solutions
- Notes from the Hiring Table, Part 2: The Recruiter Perspective
- Current SharePoint Version Updates and Next Version Updates
- PASS Summit 2009: Sunday Recap
- SSMS Tools Pack 1.7.5.1 is out! Bug fixes for my international users.
- Microsoft CEO Still Downbeat on Economy
- Business Intelligence in SharePoint 2010 poster
- Where You Can Find Me At the PASS Summit
- ICANN Approves International (國際) Characters for Domain Names
- Hierarchyid data type and AdventureWorks2008 BillOfMaterials table
- Did You Know? I'm Presenting a Whole Day of Transaction Log Info
- Deploying Reporting Services reports using msbuild
- Next SQL Down Under show - Jamie Thomson - Questions for Jamie?
- Free e-Book and Magazine
- OT Book: On the Origin of Species - Charles Darwin
- A week in Seattle
- Book: SQL Server MVP Deep Dives - Launch at PASS Summit USA
- Connect Digest : 2009-10-30
- WinInfo Short Takes: Week of November 2, 2009
- SQL Server 2008: Lock Escalation, INSERTs, and a Potential Bug
- Are You Using Scalable Shared Databases?
- PASS Summit 2009: MVP Birds of a Feather Lunch
- Bad database practices: moving data to procedures vs. moving procedures to data
- Cleaning Out Your Backup History
- #PASSAwesomeness
- Using Historical Perf Counter Data For Storage Planning
- Prepping for PASS (apparently it is next week)
- Best Practice: Naming Constraints
- Attunity Launches Suite of Real-Time Data Replication Technologies
- Virtual Auxiliary Table of Numbers
- How to 'Do' a SQL Server Conference Right
- Attunity Launches Suite of Real-Time Data Replication Technologies
- Microsoft/Yahoo! Deal Needs an Extension
- Los Angeles Dumps Microsoft, Adopts Google
- Developing Data-tier Applications Using Visual Studio 2010
- Reduce locking and other needs when updating data - Better Performance
- BI Dutch op Google Wave
- SSMS Tools Pack 1.7 is out! New feature: SQL Snippets
- New article series going on by Itzik Ben-Gan
- Script out Procedures to seperate files
- PASS Summit 2009 - Next Week!
- SSIS - Custom Control Flow Component - Execute SQL Job And Wait
- Pass the Torch
- Should I have a SNAC with my cumulative update?
- Code from Data Cleansing Session
- 64-bit desktop virtualisatie met VirtualBox – de snapshot feature uitgelegd
- SSIS: Set "work-offline" without opening the project
- PDC Session on the Data-tier Application Component
- The Possible Business Value of Twitter
- Microsoft PowerPivot
- Microsoft BI == SharePoint!
- En we noemen het: PowerPivot for Excel (the product formerly known as “Gemini”)
- Finding out problematic data in Bulk Insert data truncation error
- 10 days old
- Quick Reference: SSIS in 32- and 64-bits
- Pre-Conference at PASS
- Free SSIS Data Cleaning Session
- Performance consideration when using a Table Variable
- SQL Server - How to get the whole group of duplicate rows
- Reporting Services and the MS09-062 GDR (GDI+)
- VMware mist
- BI Consultant van het jaar ?
- SQL Saturday #23: 10.24.2009 @Louisville, KY
- Removing tags from a string
- SQL Saturday Orlando
- Business Intelligence for the DBA, Part 2
- Partitioning Tricks
- SQL Server Magazine web article about a tool I wrote
- Get a Free Kindle with Intense Training
- More on Dealing with NULLs in Integration Services
- SQL 2005: SSIS - Pushing Data to MySQL using Script Component Destination
- Business Intelligence for the DBA, Part 1.5
- Real-time, right-time, any-time?
- Microsoft CSS is back at PASS again…
- Why I prefer surrogate keys instead of natural keys in database design
- Business Intelligence for the DBA: Part 1
- New baby DBA
- Why I’m Blogging Less
- Geen Reporting Services sectie in Central Administration na installatie RS add-in
- SSIS Custom Object: Send HTML Mail Task
- Wordt het Microsoft? Of BO? Oracle heeft ook best mooi spul…
- Maximum length of each column
- My Extended Blog List (Q3 2009)
- I Am A Twit
- Reporting Services: What’s my version?
- What’s your personality type?
- Office 2010: Excel 2010, What-If Analysis aka Microsoft Finally has Built in Cube/OLAP Writeback!
- Using CNAMEs for Flexibility
- Pumped for the PASS Summit 2009
- Did your backup program/utility leave your SQL Server running in an squirrely scenario?
- If you use linked server queries, you need to read this….
- Fix for CLR object execution error after attach/restore in SQL Server 2005
- I'm Looking Forward To: Windows 7 "XP Mode" Version 2 or 3
- Perfect Conference Storm
- Dropping all temp tables
- Gebruik van sysprep en Virtual PC
- SQL Core team visited SQLPASS NL meeting
- Calling an External Query from MDX
- Creating a SSAS Rowset Action
- Webinar Recording and Demo Files
- You may not see the data you expect in Extended Event Ring Buffer Targets….
- How It Works: What are the RING_BUFFER_RESOURCE_MONITOR telling me?
- Median and weighted median
- Monitoring Process for Performance Counters
- One Year Milestone
- Microsoft's BI Certifications
- Fun with Locked Pages, AWE, Task Manager, and the Working Set…
- SQL Server 2008 R2 – Een release om over te slaan…???
- Fast and Reliable Backup and Restore of VLDBs in SQL Server 2008
- Hotfix rollup package voor Virtual PC 2007 Service Pack 1
- Calling an External Query from MDX
- The Future of SQL Server Express Installation and Voting with Microsoft Connect
- Backup SQL Server 2005 and 2008 Databases
- Cursor statuses
- It’s NUMA time!
- Twitteren zinvol?
- How to handle rotten bits
- Do-it-yourself scheduling in SQL Server
- Yes, you can truncate a table within a transaction!
- Windows 7 Virtual PC error message
- Need to inventory your Microsoft infrastructure?
- Filtering RSS Feeds
- Pentaho boek
- Another update for the Support Policy for Virtualization for SQL Server….
- Statistical SQLCLR for prediction analysis now in RC1
- 24 Hours of PASS
- How to remove a SQL Server distribution database if other methods fail
- Distributed Queries – Remote Login Permissions and Execution Plans
- NOT IN not equal to <>
- Business Intelligence Symposium
- Undocumented Function in SQL 2008
- Generate Fibonacci series - No loop, no recursion
- Defragmenting/Rebuilding Indexes in SQL Server 2005 and 2008
- Geen ondersteuning voor server OS als guest in Windows Virtual PC (Windows 7)
- PBM – it’s like liquid awesome!
- Code Camp Jacksonville
- SSASMeta - C# App to Log Info About SSAS Objects
- Come on 64bit so we can leave the mem….
- Getting Started with Variables in SSIS
- Excel 2003-2007 Assistant. NO EXCUSES to not upgrade!
- Why would Visual Studio build always rebuild a solution?
- SQL Server 2008 R2 August CTP: Utility Bug
- Rainshowers or thunderclouds? Regenbuitje of donderwolk?
- How to Generate Script along with Data?
- Inserting Records AND Getting The Identity in SSIS
- East Iowa SQL Saturday - Call For Speakers, Open Registration
- Microsoft en Qlikview
- New Jersey PASS August: Presentation Slides and Notes
- I'm Looking Forward To: Parallelism in .Net 4.0
- File Properties Task for SSIS
- How to display detailed data below each header data?
- The 24 hours of PASS
- Yo Steve, Where You At?
- Find Recently Executed Stored Procedures
- Regular expression
- The Post-Build Command Line for SSIS Custom Objects (Updated)
- IBM neemt SPSS over
- SQL Server 2005 – Fast Running Totals solution with ordered CTE update?
- Presenting at New Jersey's PASS Chapter in August
- Nog even wachten op SQL Server 2008 R2
- Vancouver PASS July: Presentation Slides and Demo Material
- Command Prompt shortcuts to open SSMS
- A Pause Task for SSIS
- Product Review: Balsamiq Mockups
- How to check when was SQL Server installed with a T-SQL query
- General Quick Reference: Batch File Tips
- T-SQL: Using CROSS APPLY to Turn 2 Queries Into 1
- Life in the Jungle
- SSAS 2005/2008: Creating Sub-Cubes Using XMLA, Variables, and Named Query Where Statements
- Using CTE’s to Create Dynamic Pivot Tables in SQL 2005/2008
- SQL Job – Check Cube Valid Data as Last Step
- Excel 2007, OLAP Cubes: Customizable, User Defined Named Sets in Excel 2007 using VBA
- CTE in a View
- Het architectuurproces, BI style
- ADOMD.NET: Could not load file or assembly Microsoft.AnalysisServices.AdomdClient
- Microsoft BI: Creating Local OLAP Cubes using XMLA and ascmd.exe
- Saas BI - Lucidera
- Defragmenting/Rebuilding Indexes in SQL Server 2005
- Social BI deel 5: Criminal Intelligence
- Export to Excel - data length exceeds 255 characters
- Ob-La-Di, Ob-La-Da, Playing around on the Piano This Morning..
- 5 Years Ago Today...
- iTunes DJ - iPhone, Remote App - Party!
- Bookmark Bar - Uber Micro Sharing
- Verslag BI-event op 11 juni
- One Year Ago Today...
- SQL Server 2008 for Developers live meeting presentation
- Google & BI
- New Bike, iPhone, RunKeeper
- SQL Server Web Developer Survey
- SQL Server Script to Display Job History
- Quirky update in sql server
- #bievent – volg het via Twitter
- Adding one file to multiple projects in a .Net solution
- SQL Server 2008 Extended Events - high performance eventing system
- BI Event, 11 juni a.s. met Rick van der Lans en Claudia Imhoff
- BI op de mobiel
- BI-freelancers verenigen zich
- Solid State Storage en SQL PASS Europe Conferentie
- Free SQL Server 2008 Powerpoint dark template
- Het dashboard van Nederland
- Informatie verzamelen, verwerken... en beslissen
- Comparing SQL Server HASHBYTES function and .Net hashing
- Sun & Oracle – het BI perspectief
- PCI Compliance and SQL Server 2008
- Open Source & OEM
- Excel / Gemini / MS BI Conference update
- SQL Server - Find missing and unused indexes
- Is there in truth not beauty?
- Backup SQL Server Databases
- Defragmenting Indexes in SQL Server 2005
- Using PowerShell to Get Data & Log File Sizes
- FastCopy - fastest Windows copy product?
- SQL Server 2008 System Views Map
- How to refresh a SQL Server database automatically
- What was my first computer and what were some of my favorite games?
- Up & Running on Win7
- What Has 2 Thumbs & Is Excited About Windows 7?
- JournalSpace: Sadly no backups
- Vista Parental Controls Slows Down Zune Marketplace
- What’s In Your Database?
- Getting Started in the Community
- Register for the SQL Server Application and Multi-Server Management Private CTP!
- 9 - 2009-11-04 21:20:57 -
- 3 - 2009-11-04 21:20:57 -
- Sharepoint
- Joomla