SQL Server 2008 and 2008 R2 Integration Services - FTP Task
FTP Task lets you copy files across distributed, frequently incompatible systems.
2011-07-01
3,288 reads
Additional Articles
SQL Server Central Management Server Security
I have seen several tips on SQL Server Central Management Server and I want to implement the technology for my team. The only thing holding me back is security. Can you explain how security works with Central Management Server? What security access is needed to manage CMS? How about connecting to CMS? How about running a query using CMS? Check out this tip to answer these questions.
2011-06-30
2,912 reads
Identify Local Administrators on a SQL Server box using PowerShell
I want to determine who the local administrators are on each of my SQL Servers. Basically, I'd like a nightly job to run against each of my SQL Servers and produce a list of admins for each server for my review. How can I do this?
2011-06-29
2,595 reads
Tempdb Space Usage in SQL Server
We all know how important tempdb is and know that tempdb gets recreated every time SQL Server is restarted. Here we dig a little deeper to focus on how space is used inside tempdb.
2011-06-28
4,893 reads
Highlighting repeating groups in SSRS 2008 R2 charts
In a typical bar chart, the height of the bars represents the value of the data along the X axis and the Y axis represents the category of the data point. All these values can be classified in logical groups depending upon the logic used for analysis. One general requirement that arises in the case of repeating groups, is to highlight these groups without representing it on the X or Y scale. In this tip we will look at how to address this requirement.
2011-06-27
2,052 reads
Fast and Free; SQL Scripts Manager's Script Generator
When William produced his second article on the free tool 'SQL Scripts Manager', revealing that it worked just as well with PowerShell and Python scripts as it does with TSQL, he thought that would be the end of the series. Oh no; in response to feedback, comes a small add-in called 'Script Generator' that makes a big difference to the speed of developing and producing new scripts.
2011-06-24
4,686 reads
SSMS: The Query Window Keyboard Shortcuts
Simple-Talk's free wallchart of the most important SSMS keyboard shortcuts aims to help find all those curiously forgettable key combinations within SQL Server Management Studio that unlock the hidden magic that is available for editing and executing queries.
2011-06-24
4,306 reads
Harnessing PowerShell's String Comparison and List-Filtering Features
When you are first learning PowerShell, it often seems to be an 'Alice through the looking-glass' world. Just the simple process of comparing and selecting strings can seem strangely obtuse. Michael turns the looking-glass into wonderland with his wall-chart of the PowerShell string-comparison operators and syntax
2011-06-23
3,099 reads
SSRS 2008 R2 KPIs with bullet graphs
Key Performance Indicators are typically displayed in a scorecard with stop light indicators, which are either red, amber or green light icons. The limitation for these kind of indicators is that you can see the actual and target values in two different fields as well as see the status of the KPI in red, amber or green color. If the user wants to figure out the thresholds associated with the KPI, these values are generally not visible. Further, representing the threshold values in the scorecard itself defeats the purpose of the scorecard. The scorecard should display the KPI's status in the most summarized form and use a minimal amount of space on the dashboard. In this tip we would look at how to address this issue.
2011-06-22
3,613 reads
SQL Peer-to-Peer Dynamic Structured Data Processing Collaboration
Unstructured and XML semi-structured data is now used more than structured data. But fixed structured data still keeps businesses running day in and day out, which requires consistent predictable highly principled processing for correct results. For this reason, it would be very useful to have a general purpose SQL peer-to-peer collaboration capability that can utilize highly principled hierarchical data processing and its flexible and advanced structured processing to support dynamically structured data and its dynamic structured processing. This flexible dynamic structured processing can change the structure of the data as necessary for the required processing while preserving the relational and hierarchical data principles. This processing will perform freely across remote unrelated peer locations anytime and transparently process unpredictable and unknown structured data and data type changes automatically for immediate processing using automatic metadata maintenance.
2011-06-21
2,436 reads
Blogs
Who’s the Winningest Coach (with AI Help)
By Steve Jones
I was listening to the radio the other day and the hosts were discussing...
Learning from Mistakes: T-SQL Tuesday #194
By Steve Jones
We’re a week late, once again my fault. I was still coming out of...
Stupid Things I Did With AI: ASCII Art
By Steve Jones
I ran across this article recently (https://www.gatesnotes.com/meet-bill/source-code/reader/microsoft-original-source-code) and it has a great opening piece...
Forums
How Do I Choose the Best Bike Transport Service in Gurgaon?
Choosing the best Bike Transport Service in Gurgaon requires careful comparison and user discussion....
Basic Always On Groups Randomly Stop Synchronizing
In one of my environments I have 3 pairs of Always On SQL 2022...
Learning From Breakage
Comments posted to this topic are about the item Learning From Breakage
Question of the Day
Adding and Dropping Columns I
I have this table in my SQL Server 2022 database:
CREATE TABLE [dbo].[CityList] ( [CityNameID] [int] NOT NULL IDENTITY(1, 1), [CityName] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) ON [PRIMARY] GOI decide to add two new columns for the StateProvince and Country. What code should I use? See possible answers