Security is a problem with so many of our applications and systems. There are numerous ways that we handle access and protection of data, often with access rights or encryption (or both) being applied to data in order to limit who can access the data. However neither of these systems is perfect for a variety of reasons and no matter how we configure our security, it seems there are always issues.
I'm not picking on Yahoo here as the same issues might exist with Microsoft, Google, or any service provider that encrypts data between its facilities. This system also suffers from the potential compromise of the keys used to encrypt traffic if any employee were to sell, disclose, or lose a copy of them on laptop.
However this is a good start, and it does mean that the NSA or any other organization that looks to read data in transit must work harder to access your data if it's encrypted. I think it's such a good idea that I think we ought to start encrypting all traffic by default. LAN, WAN, whatever. We've had tremendous advances in hardware and I'd argue that most of us have more powerful hardware than we need. If we decided t take the hit to encrypt all traffic now, we'd become used to the overhead and we'd have better security overall.
I'd love to encrypt all data on disk, but I know people get nervous about losing data. A good start, however, would be to ensure all data in transit is protected.
If you work with large scale SSIS ETL processes and sequences, you are bound to have to work with UTF-8 encoded text files. Without proper handling, UTF-8 / Unicode characters can cause havoc with your SSIS load tasks. Here are some ideas for handling the UTF-8 file formats with SSIS. More »
Nigel Sammy will be presenting this PASS Data Architecture VC webinar on December 19 at 12PM CST. The webinar will share insight on how basic query structure and logic works so you can avoid wasting too much time on trial and error when writing queries. More »
Teach yourself SQL Server Code Name Denali—one step at a time. Get the practical guidance you need to build database solutions that solve real-world business problems. Learn to integrate SQL Server data in your applications, write queries, and develop reports. Get your copy from Amazon today.
Yesterday's Question of the Day
(by Steve Jones):
I have an AlwaysOn availability group for my Sales and Finance databases set up on the SQLProd01 instance. I decided that I also want to mirror the CRM database on the same instance to another server. Do I need to create another endpoint?
All of the Availability Groups and Database Mirroring sessions use a single endpoint on an instance.
Please run the query which is showing the Host IP , BlockingSessionId, BlockingUser, BlockingSQL as a text , WhyBlocked, BlockedSQL and Database name. Blocking is an unavoidable characteristic of any relational database management system (RDBMS) with lock-based concurrency. This is normal behavior and may happen many times throughout the course of a day with no noticeable effect on system performance. The below query will help out to get the root cause why it is Blocked
select house_no order
- i have table coloum like below
3-4-53 . HYDERABAD
select house no order
i want output like below format
select quarie between houseno ..........
- i have table like below
i want out put like select only in between houseno ' 4-12-1000' to '4-12-1500'
plz write sql quarie...........
select only up to first '-' only
- I Have table like this......
select only first '-' only.............
I WANT OUTPUT LIKE THIS order ...........
display order by houseno
- i have table house no like this below coloum.........
i want table like this....
pl write the quarie..................
ssis for each loop into files help
I have the following table
CREATE TABLE [dbo].[Orders](
[orderNo] [varchar](10) NOT NULL,
[orderLineNo] [int] NOT NULL,
[product] [varchar](10) NULL,
[orderQty] [int] NULL,
[receivedQty] [int] NULL,
This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.