Search SSWUG.ORG:

Latest Video Programs

SSWUGtv: Steve and Embarcadero\'s Ron Huizenga discuss agile data modeling

SSWUGtv: Steve and Embarcadero\'s Ron Huizenga discuss agile data modeling

SSWUGtv: How do you optimize your career for learning or responsibility?   SSWUGtv: Steve and Embarcadero\'s Ron Huizenga discuss data architecture challenges.   SSWUGtv: How would you handle an employee resigning during a critical time period?  
 

From the Editor's Desk...

DBA Quick Tips  -  Today I'm providing a couple quick tips for Microsoft SQL Server that have been helpful. One helps you locate and kill all connections to a specific database. The other provides a quick count of the number of rows in a table, regardless of the table size.

Compliance Auditing  -  In today's world we often have to audit database activity. Simple audits track who modified a record. Complicated audits track modifications to column, and require history on what data a user has accessed. How do you implement and prove compliance for data auditing?

Free virtual conference...in just days now  -  The SSWUG.org virtual conference, with more than 30 sessions across 3 tracks in 2 days is this week. We're excited - and it's all free to attend! (see www.sswugvc.com)

Big Data Acquisition and Retention  -  How do you determine when to import data into your warehouse, and how long to keep it? The key is statistical relevance. Today I try to clarify the concept a little better.

Statistically Relevant  -  One of the biggest problems when creating a data warehouse is determining what to put in it. Second to that question is, how often do I need to update my warehouse? What do you think; real time, hourly, daily, weekly, monthly?

No SQL Utilization  -  What is the total capacity of your NoSQL solution? What is your current allocation? When are you going to need to increase your capacity? Some of these numbers are easy to get. Others take more effort. In trying to control costs I found it difficult to predict the future simply using tools built into NoSQL.

Cloud Use Changing - Bursting?  -  IBM's Paul Zikopoulos is talking about the cloud as a hybrid, mixed environment is changing. Specifically, how you split up workloads and attack things is changing. What do you think?

Did you know? We have more than 30 free sessions online in days!  -  Security, big data, performance, administration sessions and so much more, but the time to register is NOW.

NoSql Meta Data  -  SQL data stores provide Meta Data capabilities by default. Table Record Counts, Structure, and even space allocation are readily available. What about NoSql. Some data stores have none of the above.




Community Content - News, Articles, How-To Information and More from Around the World