Infrastructure Planning for a SQL Server Data Warehouse
In this tip we look at some things you should think about when planning for a SQL Server data warehouse.
2019-02-12
2,879 reads
infrastructure
Database Hardware and Infrastructure Trends
Glen Berry talks through a number of useful new developments in hardware, storage, and the Microsoft Windows and SQL Server ecosystem.
2016-05-23
3,214 reads
The Database Administrator's Back-to-School Checklist
To meet the upcoming demands on IT systems database administrators (DBAs) need to prepare the database and its supporting infrastructure for increased resource demands. Being proactive now can pay big dividends by maintaining service level agreements (SLAs), avoiding outages and resource shortages, and ensuring a positive overall customer experience.
2013-08-30
3,899 reads
Coping with Infrastructure Upgrades
A common topic for questions on SQL Server forums is how to plan and implement upgrades to SQL Server. Moving from old to new hardware or moving from one version of SQL Server to another. There are other circumstances where upgrades of other systems affect SQL Server DBAs.
2012-12-17
2,026 reads
Evolution and Technology: Data Warehouse Infrastructure
A look an evolution of infrastructures from Bill Immon.
2009-05-21
2,405 reads
RE: Alert is not triggered
Is there a reason that you are using a severity level of 1. Severity levels less than 11 are for informational purposes and this may be causing some of the things that you are seeing. The 16 in your Raiserror is where the <state> goes. This <state> does not seem to do much. I hope this helpsEric
2005-05-18
RE: Workflow question
Hi Steve,Can you looak athttp://www3.sympatico.ca/3005/support/dts1.htmlIs it what you mean? I'm a little confused about workflow part. Thanks, Robert
2004-10-13
How to Create Resume DB using SQL Server 2000
I'm new to SQLServer 2000 and would like to know if it is possible to createa database that would search,retreive and archieve resume? Maybe it should not be done in SQL but in Ms Access I don't but I'd appreciate any feedback. Thanks in advance.
2004-02-21
RE: Joins vs More Columns
I don't think it should be a speed issue, it's clearly a good design issue. Creating multiple tables and a view over the top of that, makes the application more flexible. Systems change all of the time, what happens when someone has three addresses or 5 phone numbers. His 1 table design doesn't allow for […]
2004-01-14
RE: myLittleAdmin?
I had a quick look at the online demo version. It looks like a nice tool for some specific needs, for example when you need to move often from machine to machine and don't have the Enterprise Manager installed on all computers.
2003-06-17
1 reads
Blogs
Hyperconverged storage tuning tip for SQL Server
By kleegeek
We all (should) know that running SQL Server in hyperconverged virtual environments, both on-premises...
Daily Coping 25 Nov 2022
By Steve Jones
Today’s coping tip is to connect with someone from a different generation. This tip...
Snowflake Classic UI vs Snowsight
By Arun Sirpal
This blog post is not about which User Interface is better, Classic or Snowsight...
Forums
Can someone explain where non - clustered index is stored?
I am learning non-clustered and clustered indexing. When reading this article https://www.sqlshack.com/what-is-the-difference-between-clustered-and-non-clustered-indexes-in-sql-server/#:~:text=Clustered%20indexes%20only%20sort%20tables,involve%20any%20extra%20lookup%20step. came across this...
Null value when checking unused indexes
I'm using this query to check if I have any unused indexes.. One of...
Retrieve Password from CyberArk using powershell
Hi, I am new to Powershell script and i have to create a power...
Ask SSC