Partitions in Analysis Services
A look at partitioning in Analysis Services from Shahfaisal Muhammed. Learn how it works, what it can do, and how to implement partitions for your cubes.
What Will We Take For Granted Tomorrow?
A guest editorial from Tim Mitchell today looks at technology, and how quickly we become accustomed to it.
Import and Export Registered SQL Servers To Other Machines
I need to setup other computers the same way that are used to manage my SQL Servers. Instead of having to manually add the registered servers on each computer in this tip I show you how you can import and export registered servers between computers.
Limited Features or Limited Time?
A guest editorial today from Andy Warren. When someone is looking to introduce a free version of a product, what's the best way to tackle it?
Using SQL Profiler to Resolve Deadlocks in SQL Server
MVP Jonathan Kehayias brings us a short article on how to troubleshoot deadlocks in SQL Server.
Tables and Views for Auditing SQL Server Logins
I have been tasked with auditing security on my SQL Server. However, this needs to be a somewhat automated process as I don't want to have to rely on taking screenshots every month to satisfy our auditors. What tables and/or views should I be using and what's the best way to extract the information out of them?
Change the Edition or Change the Design?
Today Steve Jones talks about revisiting your design and perhaps thinking about buying another edition of SQL Server to take advantage of some feature.
SQL Saturday #43 - Redmond
If you are in the Redmond, WA area, join in for a free day of SQL Server training on June 12, 2010.
Reliable Storage Systems for SQL Server
By validating the IO path before commissioning the production database system, and performing ongoing validation through page checksums and DBCC checks, you can hopefully avoid data corruption altogether, or at least nip it in the bud. If corruption occurs, then you have to take the right decisions fast to deal with it. Rod Colledge explains how a pessimistic mindset can be an advantage
Loud
Working in an office was quite a change for Steve Jones recently. He comments today that it might be something you need to consider when hiring others as well.
Blogs
T-SQL Tuesday #198 Roundup: How Do You Detect Data Changes?
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Optimizing Redshift Performance by Configuring WLM Queues
Efficient query performance in Amazon Redshift often comes down to how well you manage...
PowerShell Strikes Back: Return of the Loop
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Forums
FARE Lab's Leading FSSAI Third Party Auditing Services
If you are looking for India’s best FSSAI Third Party Auditing Services in India....
FARE Labs is The Leading FSSAI Third Party Auditing Services of India.
If you are looking for India’s best FSSAI Third Party Auditing Services in India....
Dealing with huge heap tables
Recently, our dev teams approach me for advice on improving their huge heap table...
Question of the Day
Distance Metric Algorithms
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers