Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
In Part 1, we learned how to make both Cross-Tabs and Pivots. In Part 2, we'll learn how to automate a very common type of Cross-Tab report and maybe learn some extra tricks on the way.
Would You Like a Stay Interview?
For this Friday poll, Steve Jones talks about an interesting concept. The "stay interview."
A Perspective on Database Performance Tuning
Fundamentally, database performance tuning is done for two basic reasons, to reduce response time and to reduce resource usage, both of which can apply for any given situation. Julian Stuhler looks at database performance tuning, and why it remains one of the most important topics for any DBA, developer or systems administrator.
Capturing Real-Time Currency Conversions in SSIS
Integration excels at moving and transforming data in real time. Jeff Singleton brings us a great use of SSIS in making currency conversions using a web service.
Man in the MIddle
Are you worried about man in the middle attacks on your database server? If you run Oracle you should be, but SQL Server DBAs should not assume they are safe. Adding communication encryption can be a good idea for SQL Server DBAs.
Configure Windows Firewall for SQL Server 2008 Analysis Services in Windows Server 2008 R2
As I am new to Windows Server 2008 R2 it would be great if you can let me know the step by step approach to enable the default port of SQL Server 2008 Analysis Services in Windows Firewall for user connectivity.
How to Read Excel Cells from SQL Server Integration Services
We can get data in all sorts of formats in the real world. In this new article from Dinesh Asanka, learn how to use scripting to import data from individual Excel cells.
Regular Service
Steve Jones feels that we ought to get regular service packs from Microsoft to support SQL Server. Not everyone agrees. Do you?
Consolidating SQL Server Error Logs from Multiple Instances Using SSIS
SQL Server hides a lot of very useful information in its error log files. Unfortunately, the process of hunting through all these logs, file-by-file, server-by-server, can cause a problem. Rodney Landrum offers a solution which will allow you to pull error log records from multiple servers into a central database, for analysis and reporting with T-SQL.
Concrete Code
When building a new database or system, are you designing concrete code? Should you be? Steve Jones comments on matching your needs with your architecture.
Blogs
Advice I Like: Rewards from Work
By Steve Jones
The greatest rewards come from working on something that nobody has words for. If...
Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Analysis Services Model w/ Direct Query and (Default Veritpaq)
Analysis Services (either the integrated workspace in Power BI or on a SQL Server)...
Question of the Day
Identities and Sequences IV
When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?
See possible answers